cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter SharePoint List (datatable) using dropdown

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Set the Items for data table to something like

 

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

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

9 REPLIES 9

Set the Items for data table to something like

 

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

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Anonymous
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,779)