I would like to filter the gallery objects (which are the SQL view) to be filtered based on ListBox selected items.
The ways I tried to do it:
Filter('[dbo].[xxx]',Prod = ListBox1.SelectedItems)
This line gives an error: "Invalid argument type"
When I do simple filtering based on string Filter('[dbo].[xxx]',Prod = "Food")
It works correctly.
Somehow it does work when I use "Selected" instead of "SelectedItems" like:
However it returns data filtered to first selected item (the listbox is a multiselect)
Filter('[dbo].[xxx]',Prod in Concat(ListBox1.SelectedItems,Prod & ","))
Your Listbox has to be set to a datasource for it to work so you could use something like:
on your list item box
Could you please explain a bit about the ListBox configuration, specially for the items property, and the Value part?
Basically, you should be able to filter the Gallery based on the formula below:
Filter('[dbo].[xxx]',Prod in ListBox1.SelectedItems.FieldName)
The FieldName is the field configured under the Value part.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand