Filter Table based on Lookup Fields in a Collection

[cmalm]

Seems like this should be easy. I have a collection with multiple lookup fields/records.

Long story short, I want to filter a sharepoint list that a combo box uses with all the lookup field records in the collection.

Please help!

Thanks

[WarrenBelz]

Hi @cmalm ,

When you say "all lookup fields in the collection" do you mean all fields are based in SharePoint Lookup fields?

[cmalm]

Yes the collection has the lookup fields of a sharepoint list. I want to filter the parent table/SP List that those lookup fields reference.

[v-siky-msft]

Hi @cmalm ,

Could you please show some sample data to describe the issue clearly?

My understanding is that You want to filter the Parent List Gallery by Combobox which bound to LookUp field of Child List.

If the Combobox.Items: Choices(ChildList.LookUpColumn)

then ParentGallery.Items: Filter(ParentList, ID=ComboboxName.Selected.Id)

If the Combobox.Items: ChildList

then ParentGallery.Items: Filter(ParentList, ID=ComboboxName.Selected.LookUpColumn.Id)

Hope this helps.

Sik

[WarrenBelz]

Hi @cmalm ,

With a Combo Box, PowerApps will set the Items when it adds the card, they will be Choices(YourListName.YourFieldName)

A Gallery based on this Combo Box will have the Items property

Filter(
   YourListName, 
   ID=YourComboName.Selected.Id
)

Happy to help further when you give me more specifics.

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.

[WarrenBelz]

Hi @cmalm ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.