Combine sort and filter

(0) Share

Report

Posted on by MrKoh

Hi, I want to combine below two function into one. Can anyone advice on this?

Filter(
 Search(
 'PBI Usage Log',
 txtSearchTitle_3.Text,
 "Title"
 ),
 UserId = User().Email
)

Sort(
 'PBI Usage Log',
 Switch(varSortColumn,
 "Report Name", ReportName,
 "WorkSpaceName", WorkSpaceName,
 "Report ID", ReportId,
 "Creation Time", CreatedTime,
 ID 
 ),
 varSortDirection
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MrKoh ,

Please try:

Sort( Filter( Search( 'PBI Usage Log', txtSearchTitle_3.Text, "Title" ), UserId = User().Email ), Switch(varSortColumn, "Report Name", ReportName, "WorkSpaceName", WorkSpaceName, "Report ID", ReportId, "Creation Time", CreatedTime, ID ), varSortDirection )

Best Regards,

Bof

Was this reply helpful? Yes No