I have a Gallery that is connected to a Sharepoint List, and it is filtering based on what is entered into TextInput1 text box. So far the Items property of the gallery is set to :
This is working fine, but I also need to hide gallery entries whose Owner_x0020_First_x0020_Name field is "Discarded". The options I have tried have not worked. Can someone help with this formula?
Go to Solution.
You can try the formula below:
Owner_x0020_First_x0020_Name <> "Discarded",
StartsWith(Owner_x0020_First_x0020_Name, TextInput1.Text) ||
In a Filter expression, you can pass multiple conditions, and it will only return those items that match all of the conditions.
View solution in original post
Thanks! That helped.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand