Answered

Patch inside If Statement returning error, expecting boolean

(0) Share

Report

Posted on by morall Microsoft Employee

My Formula:

ForAll(
 Gallery4.AllItems,
 If(
 IsBlank(Slot1),
 false,
 Patch('OneEng Candidates_Interviewers', Defaults('OneEng Candidates_Interviewers'), {Interviewer:Interviewer})
 )
)

I'm getting the error: Invalid argument type (Record). Expecting a Boolean value instead.

Why is the If() statement expecting a boolean value? I thought you can nest Patch() functions inside an If() statement

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
ForAll( Gallery4.AllItems, If( !IsBlank(Slot1), Patch('OneEng Candidates_Interviewers', Defaults('OneEng Candidates_Interviewers'), {Interviewer:Interviewer}) ) )

should fix it.
morall Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

that worked, can you explain why this solution works but not the one I wrote?
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@morall

Sure, it's the logic. IsBlank(Slot1) reduces to either true or false so the If() formula looks to the next element to see what action to take. Your formula would have worked if you reversed the order of "false" and "Patch(..." ie.

If( IsBlank(Slot1), Patch('OneEng Candidates_Interviewers', Defaults('OneEng Candidates_Interviewers'), {Interviewer:Interviewer}, false ) )

the false is unnecessary because if IsBlank(Slot1) is false, the If statement, as written above, would conclude without doing anything anyway but it doesn't do any harm to leave it in.