Patch a collection using an IF statement

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. I am struggling with patching a collection (text column). The patch statement works correctly :

Patch(
 colAVIssue,
 First(
 Filter(
 colAVIssue,
 varUserEmail = varUser.Mail
 )
 ),
 {SeverityLevel: "Emergency"}
)

However when I try to add an IF statement I get different errors based on what I am trying to accomplish. In a nut shell, if colAVIssue.Issue = "Complete Store Outage", I want to be able to patch "Emergency" to colAVIssue.SeverityLevel.

Hope this makes sense and thanks for the help!

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

What are you using in your If statement to find colAVIssue.Issue? Is this a selected Gallery item? What is the action that you are taking to trigger this If statement?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @ckserra33 does this mean that you want to check all records within colAVIssue for the value "Complete Store Outage"? In that case you could replace the Patch with an UpdateIf() function:

UpdateIf(colAVIssue, colAVIssue.Issue = "Complete Store Outage", {SecurityLevel: "Emergency"})

If the varUserEmail is important as a filter of the collection, use this:

UpdateIf(colAVIssue, colAVIssue.Issue = "Complete Store Outage" && varUserEmail = varUser.Mail, {SecurityLevel: "Emergency"})

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report

Hi @LaurensM thank you for the reply! So the collection will only ever have a single record. I tried both your solutions and get the error below about comparing text and table.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report

@ckserra33 Ok I understand. Could you make the following adjustment:

(remove colAVIssue. before Issue)
UpdateIf(colAVIssue, Issue = "Complete Store Outage" && varUserEmail = varUser.Mail, {SecurityLevel: "Emergency"})

Or

UpdateIf(colAVIssue, ThisRecord.Issue = "Complete Store Outage" && varUserEmail = varUser.Mail, {SecurityLevel: "Emergency"})

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report

@LaurensM That worked perfectly, thank you for the help!!

Was this reply helpful? Yes No