SubmitForm and update column value

(0) Share

Report

Posted on by Cathleen307

Hello all you smarter than me in PowerApps people,

I am still rather new to Power Apps and am still having trouble with some things.

I have created a form with user selectable fields, which is easy to submit. The problem I am having is I would also like to update the status of the row in my list without the user being able to select the status update.

In short, depending on the options the user selects, a specific save button will become visible. In the OnSelect property of the button I will submit the form, but would also like to change the status of the row to "Closed" automatically.

What function should I use in addition to the SubmitForm to make this happen?

Thank you all for your continued support.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Bipin D365 971 on at

Like (1)

Report

Hi @Cathleen307 ,

You need to use Patch function to update status column post SubmitForm.

You can get the last submitted record using Form1.LastSubmit.

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Cathleen307 58 on at

Like (0)

Report

Hello Bipin,
It worked like a charm. Thank you very much.

Was this reply helpful? Yes No
rcman 2 on at

Like (0)

Report

Is Power Apps Still useful today?

Was this reply helpful? Yes No
haziqrahim 34 on at

Like (0)

Report

Whats the alternative

Was this reply helpful? Yes No