Patch to update a record in a Sharepoint list

(0) Share

Report

Posted on by IzzyWizz

291

Hi,

I have a SharePoint list that I use to collect data from onsite audits. I have a gallery that displays the completed audit information where you can click though to display the details from a selected gallery item:

The Action Required box on the second screen is populated from the background SharePoint list for the selected item:

I have a Patch function on the update button that I want to update the Audit Type and Action Required (you can't change the image at the moment, that will be phase2!). The code is below:

Set(
 varPatchAudit2,
 Patch(
 'Hygiene Fabrication Audits',
 Defaults('Hygiene Fabrication Audits'),
 {
 
 AuditType: Dropdown1_1.Selected.Value,
 Title: Dropdown1_1.Selected.Value,
 ActionRequired: ActionRequiredInput_1.Text,
 TaskStatus: "Not started",
 AssignedBy: If(
 Dropdown1_1.Selected.Value = "Fabrication",
 FabManager,
 HygManager
 ),
 AssignedTo: "Unassigned"
 
 }
 )
);

My problem is that it is that the update is not registering anything new, i.e. if I change the Audit Type via the dropdown or the text in the Action Required, the background list is not changing. Either the Patch is not working or it is putting back the same information without picking up the changes.

Any ideas what I am doing wrong?

Thanks,

Izzy.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IzzyWizz ,

As I can see in the below-mentioned Code is like you are patching the Choices Field but you Passing value like a text.
SO If your Source having FIeld "AuditType" is Choice Field then you can Patch Value Like Below.
AuditType:{ Value:"Submitted", '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference" }
The same thing is Applicable to Person Field also.
Like for the Field - Field (If your Source Having "AssignedBy" field as a Person or Group Type)
//AssignedBy AssignedBy: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|"&Lower(User().Email), DisplayName: User().FullName, Email: Lower(User().Email), Picture: User().Image, Department: "", JobTitle: "" }

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
IzzyWizz 291 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
No, Audit Type is a text field, I just use a dropdown to limit the options for the text that people can input. I want the text that I have already patched to the Audit Type and Action Required fields to be updated with the new information, replacing what has successfully patched there previously.
Izzy.

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @IzzyWizz ,

If you want to update the existing record on change then Instead of Default you can use like below.
You need to Pass the ID of that record that you want to Update.
For reference - See below Image

Thanks,
Vijay

Was this reply helpful? Yes No