Answered

collection filtering

(0) Share

Report

Posted on by vshah2

Hello, i have a gallery and data source is the collection. I want to filer the another collection based on the selected row in gallery based on ID and get the value of the another column. Request you to please help. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @vshah2 ,
Something like this
Filter( YourOtherCollection, ID=YourGalleryName.Selected.ID, YourOtherColumn )
or
Filter( YourOtherCollection, ID=YourGalleryName.Selected.ID ).YourOtherColumn

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @vshah2 ,

I agree with most of @WarrenBelz 's thought. But I need to correct you a little. Filter function could not get field's value(formula1).

In formula2, you will get a table, not a value neither.

Do you want to filter another collection based on the selected ID in the gallery and get one column value from the filtered collection?

If so, I suggest you try LookUp function, which could get the filtered item's field value.

Try this:

LookUp( YourOtherCollection, ID=YourGalleryName.Selected.ID, YourOtherColumn )

or

LookUp( YourOtherCollection, ID=YourGalleryName.Selected.ID ).YourOtherColumn

Please refer this doc to see the differences between filter function and lookup function:

https://docs.microsoft.com/en-us/powerapps/powerapps-overview

Best regards,

Was this reply helpful? Yes No