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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
CU22080520-1 41 on at

Like (0)

Report
Copy link

Link copied!

It's not related to delegation. I've set it to 2000 limit and I only 2 rows of data.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
CU22080520-1 41 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No