web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ForAll not working for...

Power Apps

Answered

ForAll not working for a Lookup within the Loop

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

See the screenshot below.

I create a new Collection based on a ForAll.

First it finds the Maximum Version number.

Then it goes through and builds all the records (in this case 28) for that Version Number.

Note I am referring to Category_Index which is a number in the table from 1 to 28.

In colNew this Category_Index correctly gets built and is progressively number from 1 to 28.

However for Level_Index I look up the prior Quarters numbers.

This doesn't work because Category_Index for some reason doesn't change within the Lookup even though it changes in the colNew?

If I hand type in Category_Index as 1, 2, 3, 4 to 28 it works fine and pulls out the correct individual data?

Can anyone suggest what I am missing? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I suspect that Category_Index in LookUp function was referring to its own Category_Index.

Please try and use a As function:

ForAll( Filter(...) As C, Collect(colNew, {... Level_Index:LookUp( ... And(Category_Index = Value(C.Category_Index), ... ), Level_Index ) } ) )

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you very much that worked like a charm!

Was this reply helpful? Yes No

Join the conversation