You’re offline. This is a read only version of the page.
Announcements
29
Hi all,
I have a Sharepoint list "Void Orders". I need to amend a specific record from the column "OrderCreatedFlag". Everytime a click the button save, it should compare the selected item on the gallery and set the flag to "Yes". I am using the following script but it is not working.
Patch(Search('Void Orders', Gallery1.Selected.'Site Name', "{'Site Name'}"), Defaults('Void Orders'), {OrderCreatedFlag: "Yes"});
(It is showing a message that the Specific column 'Site Name' doesn't exists, but it does, and if I change from 'Site Name' to 'Name', powerapps accept it but it doesn't set the record to yes.
Could anyone help me? Is there another way of doing it?
Thank you
Regards
Marcus
Hi @marcusramos ,
Is OrderCreatedFlag a yes or no column? If so, Patch formula should be something like:
Patch('Void Orders', Defaults('Void Orders'), {OrderCreatedFlag: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:1,
Value:"Yes"}});
Regards,
Mona
Share
Report
All responses (
Answers (
