I have a datatable with a Sharepoint list as its source and I have a dropdown with distinct values from column "Room Location". How can I get my dropdown field to help only display room locations that match the dropdown?
Ie. If Conference Room 3018 is selected from the dropdown, I only want to see Room locations that equal Conference Room 3018.
Solved! Go to Solution.
I got the same issue, but that formula seems doesnt work, I have a online sharepoint list which have a Lookup column,
and that column is for the "CustomerID" which reflects on the DDCustomerID, If I put on Datatable2 Items the following "Filter(CustomerTable, CustomerID=DDCustomerID.Selected.Value) I got an error "Invocation of Unknown or unsupported function"
I need help. TIA
in my case I had to write e.g. "DDCustomerID.Value". I think the reason is that it's language specific. In my case it's the german language. some operands are different. I would prefer to have one way to write formulars and not language dependent.
Shane... My filter dropdown is returning multiple redundancies for each selection. Example: Unit 1 appears in the dropdown 5 times if there are 5 records containing Unit 1. Anyway to have Unit 1 only show up as 1 choice?
Not with that control. You can use a combobox, it works very similar. Change the filter to something like this: Filter(DataSourceName, RoomLocation in ComboBox1.SelectedItems)