News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Add two formulas in th...

Power Apps - Building Power Apps

Answered

Add two formulas in the formula bar

Like (0) Share

Report

Report

Posted on 6 Feb 2020 17:17:40 by MiMi_v88

5

Hello,

I am unable to add these two formulas in the formula bar of my powerapps.

In Gallery > Items:

Formula 1: Search('Tax T1', SearchB.Text, "Title")

Formula 2: Sort('Tax T1', Title, Ascending)

I try adding ;; between the two formulas , but it didn't work. Is there any other options?

Thank you,

All responses Img

All responses (4)

Answers Img

Answers (1)

PowerAddict 7,314 Most Valuable Professional on 06 Feb 2020 at 18:57:09

Like (0)

Report

Re: Add two formulas in the formula bar

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com
MiMi_v88 5 on 06 Feb 2020 at 18:43:40

Like (0)

Report

Re: Add two formulas in the formula bar

Thank you it worked!!!
Drrickryp Super User 2024 Season 1 on 06 Feb 2020 at 17:51:10

Like (1)

Report
Re: Add two formulas in the formula bar

Hi @MiMi_v88 ,

@PowerAddict is correct in how to address your issue. In order to better understand how PowerApps formulas work, think about wrapping one formula within another. In PowerApps, the formulas are executed from the inside out. @PowerAddict 's solution Sorts the results of the Search. However, you could arrive at the same result by

Search(Sort('Tax T1',Title, Ascending), SearchB.Text, "Title")

In this case the datasource is sorted first and then searched.
Verified answer

PowerAddict 7,314 Most Valuable Professional on 06 Feb 2020 at 17:32:14

Like (1)

Report

Re: Add two formulas in the formula bar

Do you want to search and sort? If so, you can use something like this in the Items property of the gallery:

Sort(Search('Tax T1', SearchB.Text, "Title"), Title, Ascending)

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com