Power Platform Community Forum Thread Details

Hello Power users,

I built a power app, canvas app form on Sharepoint. I have a screen where user can submit their form. Receiver will be viewed in gallery and select the record they wanted to view. I did build gallery with set(Globalvar, Gallery.Selected). I made sure display screen uses GlobalVar.Value to display in display form. Now after they view record they take action on the form with filling in choices from drop down that are on the same sharepoint row(I mean same ID). They need to update their inputs onto the same record.

How do I patch the values to existing record. This has multiple patches to make on the same record.

Any suggestions or help please?

Categories:

Building Power Apps

@KrishR

$1.png With the gallery chosen at the bottom of the screen, make it's OnSelect property: Set(Globalvar,ThisItem). The user would select the record in the gallery and then go to the Edit form (say EditForm1) which will hold all the fields in that record. It would have the same datasource as the gallery and have an Item property: Globalvar. If the gallery's datasource is a collection or has been shaped with AddColumns, or another data shaping function, then the Item property of the form would be Lookup(datasource, ID=Globalvar.ID) instead of just Globalvar.

After modifying the record, the User would press a button outside of the form with the OnSelect property: SubmitForm(EditForm1). Nothing else should be following this function in the button's OnSelect. If you wanted the user to return to the gallery after successfully modifying the form, then put: Back() in the OnSuccess property of the form. There is no need for a Patch() function as the SubmitForm() does everything. If some of the fields are required, you can click on the card in the form for that field and set the Required property of the card to true. If the user tries to submit the form without filling out these fields, a red error message will pop up and the form will not submit until data is put into that control.