Could someone help me? I have an SP online list with two fields: "Title" and "Status". The type of both field is string (text).
I need a combobox with items come from Title field with Distinct function, but previously the list should be filtered by Status field. I used this formula in the Item property of the Combobox:
Distinct(Filter(listname; filtervalue in Status);Title)
I think it should work but it does not work at all.
Note I am using Hungarian locale and in this we use semicolon ( ; ) instead of comma (,) .
This formula provides a one-column table (with Result column name ) and is not empty in my case. It"s checked in several ways.
The result of the formula can be loaded to Dropdown, Listpane, Datatable controls, and can be used in Gallery as well. All of them display the result without problem except the Combobox.
What I have missed? Any idea?
Meanwhile in the same combobox at the Item property the simple Distinct(listname;Title) formula works fine. But I need a filtered dataset ...
The purpose of Combobox to allow multiple selection, and this controls consume less space in the app then Listpane.
Thanks in advance,
Solved! Go to Solution.