Pull matching values of the records in SP list

(0) Share

Report

Posted on by HarishaAkkil

144

ClearCollect(

CollectionCode,

ForAll(

Distinct(

Filter(

CollectionA),Group),

Lookup(ListA,

columnA = Value

).columnB));

The above formula fetchs only one record that matches the criteia. But need to pull all the records that matches the value.

THanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
Hi @HarishaAkkil

try this:

ClearCollect( CollectionCode, ForAll( Distinct(Filter(CollectionA),Group), Filter(ListA, columnA = Value).columnB // Changed to Filter ) );

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
realwillwright 772 Moderator on at

Like (0)

Report
Hi @HarishaAkkil

From what I can tell of the code, you are trying to create a collection of values columnB. Doing this by filtering CollectionA and getting all unique values of the column 'Group' then doing a lookup on ListA, where columnA equals the unique value 'Group'.

How many distinct values of Group are there?

ClearCollect( CollectionCode, ForAll( Distinct( Filter( CollectionA, 1=1 ), Group ), Lookup( ListA, columnA = Value ).columnB ) );

Was this reply helpful? Yes No
HarishaAkkil 144 on at

Like (0)

Report

Hi @SpongYe ,
Getting error saying incompatiable type. The collection can't contain this value.
Please help.
Thanks.

Was this reply helpful? Yes No
SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
Hi @HarishaAkkil

Change the order of the Forall en Collect so you can loop through the items and collect the record into the collection.

ForAll( Distinct(CollectionA, Group), Collect( CollectionCode, LookUp(ListA, columnA = ThisRecord.Value).columnB ) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
HarishaAkkil 144 on at

Like (0)

Report

No doesn't work as expected, resulting the same output.

Was this reply helpful? Yes No
Verified answer

realwillwright 772 Moderator on at

Like (0)

Report
@HarishaAkkil

it looks like the collection is outside of the forall, I've moved the collection around and removed the distinct. The distinct can be added back in if required.

Clear(CollectionCode); ForAll( Filter( collectionA, 1=1 ) As dataLoad, Collect( CollectionCode, LookUp( ListA, dataLoad.<columnname> = columnA ).columnB ) );

-------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
HarishaAkkil 144 on at

Like (0)

Report

Using Lookup fetches only one data that matches in the List A, But List A has many records that has same name as DataLoad. Is there any other way to rewrite it by avoid using LookUp?

Was this reply helpful? Yes No
HarishaAkkil 144 on at

Like (0)

Report

Hi @realwillwright ,
Instead of Lookup I used Filter. It did worked. Thank you so much. You are really great.

Was this reply helpful? Yes No