cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dalacarelia_196
Level: Powered On

Filter data in a table

dropdown.JPG

2 ACCEPTED SOLUTIONS

Accepted Solutions
dalacarelia_196
Level: Powered On

Re: Filter data in a table

Its still a problem maybee Filter is not supported in the prefixed table i the app "datatabell".

 

 

 

problem.JPG

View solution in original post

Super User
Super User

Re: Filter data in a table

You are getting an error because you have placed a semi-colon inside the Filter function. Please change the semi-colon to a comma. It can be found after your table name.

Let me know if it works

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Filter data in a table

Set the Items property of the Datatable to: Filter(your_table_datsource, Code = Dropdown.Selected.Value)

—-
Please accept as solution if this is the correct answer so others may find it quicker. If you found this post helpful please give it a thumbs up.
dalacarelia_196
Level: Powered On

Re: Filter data in a table

It dosen work only thing is the name in the table changes , i want to filter the table with my dropdownlist 

As it is now the column with skola is just showing the name not the selected schools Program

 

screen2.JPG

Super User
Super User

Re: Filter data in a table

If you want to filter by two or more criteria you can add more arguments to the Filter() function. I did not see any column for Skola in your original image so that’s why I did not include it. Try this:

Filter(your_table_datsource, Code = DropdownCode.Selected.Value, Skola, DropdownSkola.Selected.Value)



Please mark as Solution if this answers the question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
dalacarelia_196
Level: Powered On

Re: Filter data in a table

Its still a problem maybee Filter is not supported in the prefixed table i the app "datatabell".

 

 

 

problem.JPG

View solution in original post

Super User
Super User

Re: Filter data in a table

You are getting an error because you have placed a semi-colon inside the Filter function. Please change the semi-colon to a comma. It can be found after your table name.

Let me know if it works

View solution in original post

dalacarelia_196
Level: Powered On

I Got it now Thnx so mutch

Thanx i find the solution now you are my helping hand heroes .

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,104)