Combining sort, filter and search using tabs

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Experts,
I am trying to use sorting (from latest to oldest using Start Date) in my gallery and I want to combine these functions, but I can't seem to get it to work and there is an error using Sort and SortbyColumns.

Below is my code, the gallery is set to show by tabs.

If(varTab="Pending", 
Filter(Tasks, 'Tasks (Views)'.'Pending Tasks' StartsWith(Subject, searchBoxA.Text))
,
varTab="History", 
Filter(Tasks, 'Tasks (Views)'.'My Completed Tasks', StartsWith(Subject, searchBoxA.Text)))

Any help is appreciated!

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If the 'Start Date' field is included in 'Tasks (Views)'.'Pending Tasks' and 'Tasks (Views)'.'My Completed Tasks'

Try this formula:

Sort( Switch( varTab, "Pending", Filter(Tasks, 'Tasks (Views)'.'Pending Tasks' StartsWith(Subject, searchBoxA.Text)), "History", Filter(Tasks, 'Tasks (Views)'.'My Completed Tasks', StartsWith(Subject, searchBoxA.Text)) ), 'Start Date', Descending )

Hope it helps !

Was this reply helpful? Yes No