web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch Failed

Power Apps

Answered

Patch Failed

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Currently, I am doing an update mode for a SharePoint List.

This is the code that I run on the "edit button",(updateusers is the variable)

image002 (2).png

This the code that I run on the "Save button"

image003 (2).png

When I run it, it showed me an error message and it didn't update the data

image001 (3).png

Why is this happening? Is there any way to solve this problem?

Thank you

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I can solve the first problem, as I forgot to add Text for the Text Input and it runs successfully but the problem is:

When I start to update, it will create a row with the updated value in it instead of updating the specific row.

This is the formula that I used at the "Save" icon.

This what happened, when I perform the update:
1) I click on the 'Pencil' icon to perform the edit:

2) I start to perform the edit and click the "Save" icon after completing the update
3) After that, it does not update that specific item instead it creates a new row.

Why is this happening, is there any way to solve this problem?

Thank you.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :
Do you want to modify the specific record instead of add a new record?
Is the data source of the gallery 'Peple that has acccess to data'?
I assumue the gallery's items property is 'Peple that has acccess to data'.
Firstly,let me explain why you can not modify the specific record.
The key is that you need to use the record you need to modify as the second parameter of the Patch function.
The correct syntax is:
Patch( DataSource, BaseRecord, ChangeRecord1)
Secondly,I suggest you try this code:

Patch('Peple that has acccess to data',ThisItem,{'user ID':ThisItem.'user ID',Users:'Users input'.Text,'Scope of access':'Scope of access input'.Text})

Best Regards,
Bof

Join the conversation