Trying to do an if() statement in a ForAll(Collect()) statement

(0) Share

Report

Posted on by martinav

3,347

I need an if() condition in a ForAll(Collect()). Simple as this:

ForAll(KDL_Data_All,If(LookUp(Combine_All,PartNumber=KDL_PartNumber,PartNumber)=Blank(),

 Collect(Combine_All,{
 PartNumber:KDL_PartNumber,
 If(LookUp(ACCT_Data_All,ProductID=KDL_PartNumber,Title)=Blank(),AcctDesc:"<NO ACCTIVATE>"),
 KDL_Desc:KDL_Title,
 MD_Description:"<NO_MDL>"})
 
 )
)

I'm guessing I'll have to wrap an If() around Collect() instead?? I'd rather only have the one statement, but I guess it will do...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

**Ran a test, this solution didn't work

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@martinav

I agree with @Anonymous that the current code will not work. This is because the field names in Collect (i.e. AcctDesc) cannot conditionally exist.

My idea is always include AcctDesc and use the IF statement to control what is written to the field.

ForAll(KDL_Data_All,If(LookUp(Combine_All,PartNumber=KDL_PartNumber,PartNumber)=Blank(), Collect(Combine_All,{ PartNumber:KDL_PartNumber, AcctDesc: If(LookUp(ACCT_Data_All,ProductID=KDL_PartNumber,Title)=Blank(), "<NO ACCTIVATE>",LookUp(ACCT_Data_All,ProductID=KDL_PartNumber,Title)), KDL_Desc:KDL_Title, MD_Description:"<NO_MDL>"}) ) )

Can you please give this a try? I believe it would be faster for you or @Anonymous to do the test since you already have it setup.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
martinav 3,347 on at

Like
a
(1)

Report
Copy link

Link copied!

Huh, strange. That is exactly what I was trying to do. I must have been a parenthesis off or something. Not sure what happened. That worked fine, as it should have!

Thanks much.

Was this reply helpful? Yes No