Update SharePoint list item with PowerApps form

[FFigueiredo]

Hello everyone,

I have a problem updating an item in a sharepoint list with an edit form in PowerApp.

I have an item in a sharepoint list with some fields already filled in and I need to update that item, in this case add information to empty fields (fields entered in the form) to some columns of that item.

The SubmitForm formula doesn't work because it creates a new item instead of updating and I only need to update the specific item.

How can I solve the problem?

I think it is through the Patch formula but I can't do that.

Thank you all.

[PowerAppAlex]

Hey @FFigueiredo ,

Check out this post video by Shane Young: https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/PowerApps-Patch-Function-for-SharePoi... 

This should help you learn how to update items with the patch function.

Kind Regards,

PowerAppsAlex

[eka24]

SubMitForm works for both creating new item and editing existing item. The Issue is whether at the time of submission, the form is in DefaultMode.Edit or DefaultModeNew.

Therefore to edit, insert another button and on OnSelect of the button put: EditForm(YourFormName). This will put the form in edit mode. Any update you do in the form will replace the updated field after you hit the SubmitForm Button

Also consider the following if you have not done already:

To ensure what appears in the form for editing, you can insert a Gallery and set the item to the Datasource. Then in the Item of the form, put Gallery1.Selected (That whatever you click in the gallery appears in the form for Editing to be done)

[v-xida-msft · Accepted solution]

Hi @FFigueiredo ,

Do you want to update existing item in your SP List using Edit Form?

Actually, the SubmitForm function could create a new item or update an existing item in data source, which is based on the mode of the Edit form. If the Edit form is in New mode, the SubmitForm function would add a new entry into your data source. If the Edit form is in Edit mode, and the Edit form has been bind to the existing record, the SubmitForm function would edit the existing record in your data source.

So if you want to use the Edit form to edit existing record in data source, please take a try with the following workaround:

Set the DefaultMode property of the Edit form to following:

FormMode.Edit

set the Item property of the Edit form to following:

LookUp('Your SP List', PrimaryColumn = "xxx Specific Value  xxxx")  // find the specific record in your SP List

then when you press the "Submit" button, the form data would be saved back to your SP list, the existing record would be changed.

You could also consider generate an app based on your SP List, then it would generate three screens automatically. Then you could find the specific record you want to update within the BrowseGallery, then select it, it would navigate to the Detail Screen, then you could click the "Edit" button within the Detail screen to edit current record.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/app-from-sharepoint

Best regards, 

[eli-g]

Hi @v-xida-msft 

Trying to build powerapp form that collects additional data about a sales account (column title -= opp name) already entered on an SP list.

A few things I want to set up:

1. Have the opp name pre-filled in the app when the user gets the link so that they know the subsequent questions they're answering are only related to that specific opp.

2. Bind the form to that opp name so the form knows which row to update with the responses

My edit form is defaulted to edit mode and I did try your lookup formula but am getting an error that the name isn't valid and this identifier isn't recognized.

Any advice on how to accomplish the above?

Thanks!