UpdateIf Not working for me

(0) Share

Report

Posted on by Mattw112b

1,088

I have two SharePoint Lists.

One is Clients and one is Sales

Both have a "Client" column which is the client name.

I have a edit form in PowerApps and I can edit the client names in the Clients list, no problem. but I also want to update the client names across all sales records too if someone edits the name.

So onsuccess for the edit form, I added this:

UpdateIf(
 VirtualPZone,
 Client = OldClientName,
 {Client: NewClientName}
)

It doesn't give me any errors, but it just doesn't update. I have verified the names in the SharePoint list match the variables in OldClientName.

Am I using UpdateIf incorrectly? Like I said it doesn't give me any errors.

Could it be because across Data Sources I have more than one "Client" column?

Thanks,

Terry

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

HI @Mattw112IG
Ambiguity can cause these type of issues, however you have only mentioned one in your code with no reference to the other list.
The other issue is that you have probably just updated a record that UpdateIf is also about to update.
To test this theory, put the UpdateIf on a button and see if it works from there.

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

So it did work from a button...

But I am not editing the record I am trying to updateif, I am editing the clients list, then trying to updateif the sales list...

Thanks,
Terry

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

Hmm, so after my last post I put the code back in the onsuccess, deleted the button, etc. and reran and it worked??

Only other thing I did was save and close the app and then reopen it. I'm wondering if it wasn't updating because the app just needed to be restarted?

Thanks!
Terry

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Mattw112IG ,
My bit of detective work was only on the basis that you said it was not working (which it should have been) and I was trying to eliminate a possible cause - and yes - saving, closing and reopening is sometimes a good idea after changes.

Was this reply helpful? Yes No