Notifications
Announcements
Hello together,
I try to built a gallery that can be filtered with two comboboxes ("ComboBoxStatus", "ComboBoxName").Datasource is "List 1" and filtered columns are "status" and "name".Multiple selections in each dropdown should be possible.
Can anyone help me with the function for filtering?
Thank you,
Lukas
Hey @victorcp,
thank you so much for your help, now it works perfectly like I need!
I was a bit concern about this error and just test it form my side and got the same error. Apparently there was an update that make it not work as it should.
so here it is how I make it work:
Filter( 'List 1', status.Value in ForAll(ComboBoxStatus.SelectedItems,Value).Value || IsBlank(ComboBoxStatus.Selected.Value), name in ForAll(ComboBoxName.SelectedItems,Value).Value || IsBlank(ComboBoxName.Selected.Value) )
Please let me know if it works
Hi @luwu_7100 ,
Please replace ; by ,
Filter(Datasource,Status.Value in ComboBox3.SelectedItems.Value)
Also please confirm "ComboBoxStatus", "ComboBoxName are choice types column and mutli-selection if off from SharePoint list
Please click Accept as solution if this helped you solve your issue. This will help others find it more readily. It also closes the item. Please consider giving it Thumbs Up.
Hey, here is the error message. In my question I wrote "List 1" and "ComboBoxStatus" to make it easier to understand, thats why the names are a bit different here.
I tried it at first just with only one condition to make sure this works before i add the second ComboBox. Sorry for German syntax. The error means "This datatype can't be converted. PowerApps can't convert this data from "text" to "record".
Hello!
as you mention before, status is a 'Choice' column so to access the information stored in this column you have to select the property 'Value' and for 'Sigle Line of Text' columns it is not necessary that's why name is without 'Value'.
Regarding the error could you please take a screenshot of the formula and place it here? because I never see that error in this context
Hey @victorcp ,
I tried your formular, but ".value" from "status.value" is underlined with the information that powerapps can not convert datatyp from type text to type record.
And why du you use "status.value" for the first condition and just "name" without .value in the second?
Thanks,
Hello,
so the formula will be this:
Filter( 'List 1', status.Value in ComboBoxStatus.SelectedItems.Value || IsBlank(ComboBoxStatus.Selected.Value), name in ComboBoxName.SelectedItems.Value || IsBlank(ComboBoxName.Selected.Value) )
I hope it helps 🙂
I set the combobox items with
Distinct('List 1', Status)
And in my sharepoint list its a choice column that does just allow one choice in each row.
it will depend on how you set the combobox items, could you share it here please? and also the columns types?
Hey Tiksha,
thanks for your idea. Unfortunatley it doesnt work because ".Value" in Status.Value is underlined red and says that text cant be used in this context.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 428
WarrenBelz 374 Most Valuable Professional
MS.Ragavendar 333 Super User 2025 Season 2