Iterate though a collection in Powerapps

(0) Share

Report

Posted on by JasonHoffoLeic

Hi there,

I have a collection with three words inside of it.

like so :

I am trying to query this collection with other rows in Dataverse and i am attempting to use the ForAll Command - like so :

ForAll(CarrierNameA,
If(
CountRows(
Filter(
RippleCarriers,
CarrierName = ThisRecord.CarrierName && 'Send to RUM (RippleCarriers)'.Yes
)
) > 0,
Collect (
Triglav,
{Result: "True"}
),
Collect (
Triglav,
{Result: "False"}
)
));

And it is working but it is giving me 3 trues in the new collection and not just one. I want it to query each row itself and not give me 3 results.

What can i do to get ForAll to work over the collection but only give me one row on the collection that the ForAll updates ?

I am so stuck.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JasonHoffoLeic ,

You could try the following formula:

If(CountRows(Filter(
ForAll(CarrierNameA As Ca,
!IsEmpty(Filter(RippleCarriers, (CarrierName = Ca.CarrierName)&&'Send to RUM (RippleCarriers).Yes' ))
),Value=true)
) > 0,
Collect (Triglav,{Result: "True"}),
Collect (Triglav,{Result: "False"})
);

Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.
JasonHoffoLeic 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes brilliant, i was missing the 'As' !!! THankyou very much.