1

I am trying to update my field "Status".

I am using the logic from here: Create and Update Patch Formula for Power Apps

 Patch('Questionnaire',
LookUp('Questionnaire',ID=Value(DataCardValue20.Text)),
{Status:"Submitted"});

SubmitForm(EditForm1_1);Refresh('Questionnaire')

but nothing changes when I click my submit button.

DataCardValue20 is my ID field. What could I do here to fix this?

enter image description here

3
  • If Patch and SubmitForm is on same data source, try using SubmitForm function first and then Patch function. Let me know if it works. Commented Feb 4, 2023 at 15:12
  • @GaneshSanap yes that worked... not sure why...
    – Jonnyboi
    Commented Feb 4, 2023 at 21:19
  • Check my answer below. Commented Feb 5, 2023 at 1:30

1 Answer 1

1

You are facing this issue because you are using SubmitForm function after Patch function.

SubmitForm is overriding the value you set using Patch function.

So, try using this:

SubmitForm(EditForm1_1);
Patch('Questionnaire',
LookUp('Questionnaire',ID=Value(DataCardValue20.Text)),
{Status:"Submitted"});

Refresh('Questionnaire')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.