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.
Set the Items for data table to something like
Filter(DataSourceName, RoomLocation = Dropdown1.Selected.Result)
Set the Items for data table to something like
Filter(DataSourceName, RoomLocation = Dropdown1.Selected.Result)
PERFECT!!!!! Thank you very much!!
Is there a way to select all options, in case a user wants to see them all instead of just one conference room?
Hi Shane,
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
Hi 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.
Greetings, Alex
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)
Do you use distinct to only show the distincs values in the filter dropdown?
No. I had not used it. It only shows "Table1" which is the Datasource
User | Count |
---|---|
251 | |
102 | |
94 | |
47 | |
37 |