Filtering a gallery based on a multi select combo box with a lookup field in sharepoint list

(0) Share

Report

Posted on by FA-18030952-0

Hi

I'm quite new to powerapps and any help is much appricated.

I have a field called sector in the my sharepoint list which is a lookup from the sectors list
I want to filter my gallery based on this sector field using a combobox. The user can select more than one sector to view at one time.

How can I do this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,075 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@FA-18030952-0,

Let add the items property to your ComboBox (cmb_Sectors)

Items Property: Choices(Sectors)

Filter Your Gallery

Filter(
YourSharePointList,
IsEmpty(cmbSectors.SelectedItems) || Sector.Value in cmbSectors.SelectedItems.Value
)

Note : lookup field stores value as records not a plain text, so always refer by either .Value or .Id correctly

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

Was this reply helpful? Yes No
MS.Ragavendar 7,075 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@FA-18030952-0,

Is your issue resolved?

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

Was this reply helpful? Yes No
Suggested answer

Inogic 1,285 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Below are the steps to filter a gallery in PowerApps based on multiple selected sectors from a ComboBox:

To filter your gallery based on multiple selected sectors from a ComboBox, set the ComboBox's Items property to Choices('YourSharePointList'.Sector), ensuring "Allow multiple selections" is enabled.

Then, set the gallery's Items property to Filter('YourSharePointList', Sector.Value in ComboBox1.SelectedItems.Value).

Replacing 'YourSharePointList' with your actual SharePoint list name and ComboBox1 with your ComboBox name. This ensures the gallery displays only records where the sector matches any of the selected values in the ComboBox.

Hope this helps.

Thanks!

Inogic

Was this reply helpful? Yes No