Answered

Additional rows submitting when default value of data card textbox is updated via context variable.

(0) Share

Report

Posted on by quinncain

I have an edit form with a hidden data card "Approval Status" with a text box value that changes depending on whether a user selects "Save Progress" or "Submit for Approval". This works when the user submits the form for the first time, but when the user goes to generate the form for the next step, 2 extra rows are being submitted that contain only the approval status' "Pending" and "Temp", (the 2 approval status that are swapped between depending on the button clicked on the form). Why are these extra rows being submitted?

Save Progress OnSelect():

UpdateContext({tempsave:1}) ; SubmitForm(SummaryFormLCG1) ; SubmitForm(PlanningFormLCG1) ; SubmitForm(FinancialsFormLCG1)

Submit for Approval OnSelect():

UpdateContext({tempsave:2}) ; SubmitForm(SummaryFormLCG1) ; SubmitForm(PlanningFormLCG1) ; SubmitForm(FinancialsFormLCG1)

Approval Status Default:

If(tempsave = 1, "Temp", "Pending")

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

quinncain 59 on at

Like (0)

Report
Copy link

Link copied!
I figured out that this issue was due to the submit functions. The submit functions were submitting each page as a different row.
New code looks like this, and appears to be working:

UpdateContext({tempsave:1}) ; Patch(datasource, Defaults(datasource), SummaryFormLCG1.Updates, PlanningFormLCG1.Updates, FinancialsFormLCG1.Updates)

Was this reply helpful? Yes No
quinncain 59 on at

Like (0)

Report
Copy link

Link copied!

This works for when the user moves to a new gate in the project, and creates the new row correctly, but is there a way I could modify this formula to have it update the row selected in the Gallery at the beginning of the process?

Was this reply helpful? Yes No