web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to write 2 formula...

Power Apps

Answered

How to write 2 formulas in a gallery

(0) Share

Report

Report

Posted on by TheRice

5

So i want to write 2 formulas in my gallery,one to sort it after a variable ,and another to filter it from a text input .The formulas work by themselves,but when i want to combine them they dont work.How can i combine them so they work?
-Filter(FlooringEstimates,StartsWith(Name,cauta.Text))
-If(!IsBlank(pret), SortByColumns(FlooringEstimates,"Price",If(pret=true ,Ascending ,Descending)),FlooringEstimates)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
To do what you want you should nest the formulas. Simply replace FlooringEstimates in the second formula with the whole Filter() formula like this.

If(!IsBlank(pret), SortByColumns(Filter(FlooringEstimates,StartsWith(Name,cauta.Text)),"Price",If(pret=true ,Ascending ,Descending)),Filter(FlooringEstimates,StartsWith(Name,cauta.Text)))
TheRice 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you 🤡 it worked

Join the conversation