web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Multiple functions in ...

Power Apps

Answered

Multiple functions in powerapp gallery

(0) Share

Report

Report

Posted on by AhsanNaeem

5

Hello,

I am new to Powerapp development. These two functions work perfectly in gallery:

SortByColumns(Search([@'[dbo].[BMS_Jobs]'], TextSearchBox1.Text,"ClientName","CostCenterDescription"), "ClientName", If(SortDescending1, Descending, Ascending)

and

Filter('[dbo].[BMS_Jobs]',FilterText.Text=CostCenterStatus)

All I want is to make both of these functions active in gallery.

Please guide.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@AhsanNaeem
If I understand correctly you want both sets of functions to be applied at the same time. Here's how you can do that.

SortByColumns( Search( Filter( '[dbo].[BMS_Jobs]', FilterText.Text=CostCenterStatus ), TextSearchBox1.Text,"ClientName", "CostCenterDescription" ), "ClientName", 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."
AhsanNaeem 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @mdevaney

Join the conversation