Answered

collection filtering

Like (0) Share

Report

Posted on 16 May 2020 04:34:01 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:

General Questions

All responses (2)

Answers (1)

Verified answer

v-yutliu-msft on 18 May 2020 at 05:31:17

Like (0)

Report
Re: collection filtering

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,
WarrenBelz 146,645 Most Valuable Professional on 16 May 2020 at 05:58:42

Like (0)

Report
Re: collection filtering

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.