I am new to PowerApps and Excel formulas
I have a Gallery and I want to add multiplr formulas to the Item filed in order to have a sort option, a text search option and a dropdown list filter option.
I have each formulas individually create and they work one at the time:
Sort(ITTicketsCases, ID, SortOrder.Descending)
Search(ITTicketsCases, TextInput1.Text, "Technician")
Filter(ITTicketsCases, Dropdown1.Selected.Value in Status)
How do I combine them into a single line to be able to use all the options above?
Go to Solution.
If I understand correctly you want to specify the data source for the Gallery control.
In this case, the Items gallery property will be:
Sort(Search(Filter(ITTicketsCases, Dropdown1.Selected.Value in Status), TextInput1.Text, "Technician"), ID, SortOrder.Descending)
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.