Update Sharepoint List with PowerApp

[yunho_534]

Hello,

I am completely new to PowerApps and I've searched for hours trying to find the answer to this problem I have, but either the solutions I've found don't work for my specific situation or I am not knowledgeable enough to apply the solutions properly.

I have a sharepoint list containing some columns that are prefilled and others that aren't. For example, let's say that I have the following item in my sharepoint list:

ID	Email	Date	Status	Comments
1	Asdf@asdf.com

So the first two columns are already filled and the other three aren't. The PowerApp already has the [Date] pre-populated with today's date, [Status] is a drop-down list, and [Comments] is a long-text. Both ID (system-generated) and Email are hidden in the PowerApp since I don't want those to be edited.

I have a Power App form that contains those three columns as fields for the user to fill in with a submit button.

I also have a Power Automate flow that sends the user an email with the link to the PowerApp as soon as the item is created in the Sharepoint List so that they can submit the form in PowerApp to update the item with the other three columns filled in.

Whenever I press the submit button on the PowerApp, a new item gets generated like below:

ID	Email	Date	Status	Comment
1	Asdf@asfd.com
2		8/10/2021	Complete	Blah Blah Blah

Instead, I need all of the information updated to the first line like this:

ID	Email	Date	Status	Comment
1	Asdf@asdf.com	8/10/2021	Complete	Blah Blah Blah

I've looked into form edit, patch function, matching by ID, and tons of videos., but nothing seems to be working.

I would appreciate any help with this issue.

Also, apologies if there's already a solution to this issue, I probably just don't know how to make that solution work in my case.

Thank you!

[RandyHayes]

@yunho_534 

You don't need patch, you just need to make sure your edit form is using the correct record.

So, what is the Item property of your form?

[yunho_534]

@RandyHayes 

The Item property is blank. I know that some solutions included something related to SharePointIntegration, but that field isn't recognized in my PowerApps form.

[RandyHayes]

@yunho_534 

How are you selecting the record from your list?

Or, in other words, did you create your app as a standalone app or as a customize forms from sharepoint?

[yunho_534]

@RandyHayes 

I created the app as a blank canvas and connected it to my sharepoint list as a data source.

[RandyHayes]

@yunho_534 

Okay, very good.  So, what method are you using to select the record in your list, a gallery, some function, etc?

In other words, you show a record with ID 1 in your post that you want to update....how is it you are determining that record ID 1 needs to be updated?

[yunho_534]

@RandyHayes 

I think that's where my issue is. I don't know where to specify that. I thought it would be done in the Item property by using a lookup function to match with the ID, but that doesn't seem to work. I have the ID as a parameter in the URL. I also have the actual ID_DataCard default value set to that parameter value.

[JayashreeKrish]

can u send a screenshot of you power apps screen ? 

[RandyHayes]

@yunho_534 

Yes, it can be that, but is that the method you are going to use to select the item in the list...the URL param?

[yunho_534]

@JayashreeKrish 

Unfortunately, I can't show you the PowerApp, but I can show you the contents of the properties.

@RandyHayes

It doesn't have to be the URL parameter. If there's another way of doing it, I am open to it. I feel like this shouldn't be a complicated thing to do. Here's a screenshot of the properties of the submit button.

Here's what I currently have in the properties for the Form:

I tried to use currentRecord.ID in the Item property, but I would get an error "Invalid use of ."