Hey, guys. I'm trying to filter a table by two conditions (dropdown lists) BUT I can't even set one condition!
The formula I'm trying:
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Value)
It's not working and I stil need to filter with the second dropdow...
Hope you guys can help me.
There is a screenshot attached.
Solved! Go to Solution.
Usually, this should be working except if the dropdown is Distinct, in that case:
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Result)
With the second dropdown
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Result&&Dropdown3.Selected.Result)
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Result&&Dropdown3.Selected.Value)
You guys have an reference where I can learn the diferences between "SelectedText" "Selected.Value" "Selected.Id" and so on??
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.