Answered

Patch to sharepoint list record not working

(0) Share

Report

Posted on by kORINNERB

Hi,

I ma trying to patch the below to my sharepoint list called QHSE App, when i do it does not seems to work or it creates a new record rather than patching to the record in QHSE Audit App. Can you advise? I have it set up in a gallery and want it to patch to the the one i have checked on the tick box in the gallery

ForAll(RenameColumns(Filter(qhseall,ticked),"ID","TEST"),Patch('QHSE Audit App',LookUp('QHSE Audit App',ID = TEST),{'Non Conformance Status':Dropdown4_1.Selected},{'Non Conformance Date':DatePicker3.SelectedDate}));Notify("Your audit has been saved",NotificationType.Success);ClearCollect(qhseall,AddColumns('QHSE Audit App',"ticked",false));Refresh('QHSE Audit App')

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@kORINNERB

Your formula is using the ForAll backward...ForAll creates a table to use to submit to your Patch function.

Also, there is no need to incur the expensive Refresh function in your app.

Please consider changing your Formula to the following:

Patch('QHSE Audit App', ForAll( Filter(qhseall, ticked) As _item, {ID: _item.ID, 'Non Conformance Status':Dropdown4_1.Selected, 'Non Conformance Date':DatePicker3.SelectedDate } ) ); Notify("Your audit has been saved",NotificationType.Success); ClearCollect(qhseall, AddColumns('QHSE Audit App', "ticked", false))

That said, I would drop the collection to get the "ticked" values for your Gallery. You can get those without a collection.

Example:

Patch('QHSE Audit App', ForAll( Filter(yoruGallery.AllItems, yourCheckBox.Value) As _item, {ID: _item.ID, 'Non Conformance Status':Dropdown4_1.Selected, 'Non Conformance Date':DatePicker3.SelectedDate } ) ); Notify("Your audit has been saved",NotificationType.Success);

Also, the above ALL assume the Dropdown and the Datepicker are NOT in the actual gallery but outside of it. If inside, then prepend those control names with _item.

I hope this is helpful for you.

Was this reply helpful? Yes No
kORINNERB 96 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Randy

Thank you agree with your suggestion so have gone wiht your second formula and tweaking the gallery and check box details it has worked perfectly, thnak you so much for your help

Kind Regards

Korinne

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@kORINNERB

No problem...happy to help.

Was this reply helpful? Yes No