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