Unanswered

UpdateIf Function Not Working

(0) Share

Report

Posted on by CU22080520-1

A very weird thing just happened recently. Before today, I was able to use "UpdateIf" function perfectly. Today, it just won't work.

So in my canvas Power Apps, I have direct link to Sharepoint List as my data source. That list only has 1 column, which is "Title". I tried to execute a very simple function as shown below:

UpdateIf(MyList,Title = "Testing",{Title: "Success"});

It should have worked. But somehow, after execution, it does not update the value in my Sharepoint List. What went wrong? Why is it not working now like it is supposed to?

Categories:

General Questions

All responses (5)

Answers (0)

ronaldwalcott 903 on at

Like (0)

Report

UpdateIf Function Not Working

Add an error check something like

If(Errors(MyList).Count > 0, Notify("Some records failed to update", NotificationType.Error));

to the end to see what error is being generated.
CU22080520-1 31 on at

Like (0)

Report

UpdateIf Function Not Working

Yes I monitored it. Power Apps passed on the values correctly to the variables (columns). The values in Sharepoint remains the same as if no update was done.

If I use RemoveIf fuction, it work perfectly. The Patch function also work perfectly. Can it be corrupted in some way?
ronaldwalcott 903 on at

Like (0)

Report

UpdateIf Function Not Working

Did you confirm that the Title column in the SharePoint list is Testing?

Did you try using Monitor to see what happens?

Did you try performing a Lookup to see if it can retrieve the value from the SharePoint list?
CU22080520-1 31 on at

Like (0)

Report

UpdateIf Function Not Working

It's not related to delegation. I've set it to 2000 limit and I only 2 rows of data.
mmbr1606 9,952 on at

Like (0)

Report
UpdateIf Function Not Working

hey

how many items does this list have? is it over the delegation limit?

can u try this:

ForAll( Filter(MyList, Title = "Testing"), Patch(MyList, ThisRecord, {Title: "Success"}) )

did u check if the right permissions (edit) is set?

if my answer helped please mark as verified,

cheers