web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collections Patch, wit...

Power Apps

Answered

Collections Patch, with If

(0) Share

Report

Report

Posted on by adrianlochan

53

Hello

I am new to PowerApps and trying to patch using ForAll with a condition using If a value is greater than 0.

Here is part of my formula, I've tried several versions without success. Any help is appreciated.
ForAll(IncomeCollection, If(IncAmt.Value > 0), Patch(IncomeDetails, Defaults(IncomeDetails), {Income_Amount: IncAmt}))

Thanks

Adrian

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @adrianlochan ,

Change your formula as below:
ForAll(IncomeCollection, (If(IncAmt.Value> 0, Patch(IncomeDetails, Defaults(IncomeDetails), {Income_Amount: IncAmt})))

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Verified answer

adrianlochan 53 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @KrishnaV Krishna,
Thanks for the reply, that was helpful.
However along with the If in brackets I found that for me I had to take out the .Value and it worked.

Join the conversation