I have a power app that works in the search bar adding an ID and that part is working properly. However, i want to show as default (When the search box is blank) my logs status.
This is the formula that i am using for the searchbox:SortByColumns(Filter([@'Queries'], 'ID'=Value( TextSearchBox1.Text)),"Title", If(SortDescending1, Descending, Ascending))
My column of status is called Status and is a choice variable with 3 options Open Solved or Inconclusive.
Thanks for any help
Go to Solution.
@Anonymous To show everything when the searchbox is blank use this code in the Items property of your gallery.
TextSearchBox1.Text=Blank() Or 'ID'=Value(TextSearchBox1.Text)
If(SortDescending1, Descending, Ascending)
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.