cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JeanFB3116
Frequent Visitor

Using multiple formulas in a gallery

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Oleks
Advocate I
Advocate I

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)

-Oleks

View solution in original post

1 REPLY 1
Oleks
Advocate I
Advocate I

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)

-Oleks

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,031)