Filter SharePoint List (datatable) using dropdown

[Anonymous]

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.

[Shanescows · Accepted solution]

Set the Items for data table to something like

Filter(DataSourceName, RoomLocation = Dropdown1.Selected.Result)

[Anonymous]

PERFECT!!!!! Thank you very much!!

[Anonymous]

Is there a way to select all options, in case a user wants to see them all instead of just one conference room?

[PMCPajadan]

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

[lexschulz]

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

[Jaymarhonda]

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?

[KvB1]

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)

[KvB1]

Do you use distinct to only show the distincs values in the filter dropdown?

[Jaymarhonda]

No. I had not used it. It only shows "Table1" which is the Datasource