Answered

How to Sort and Filter Gallery at the same time

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi there,

I am currently working on the gallery portion of the application. Currently at the gallery level, I have used Items :If(varAdmin, 'Big Ideas Tool', Filter('Big Ideas Tool','Created By'.Email=User().Email)) and set the Onvisible:If(User().Email="xxx@abc.org",Set(varAdmin,true)); UpdateContext({varDateSort:Blank()}) to set that email address as an admin to to view all information. Any other email address would only be able to see their results. I want to put a Sortbycolumn function to sort the gallery by date but its not allowing me to filter and sort the list at the same time.

If(varAdmin, 'Big Ideas Tool', Filter('Big Ideas Tool','Created By'.Email=User().Email)) ;
SortByColumns('Big Ideas Tool',"Date")

this function is keep failing me. Help will be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Please consider changing your Formula to the following:

SortByColumns( Filter('Big Ideas Tool', 'Created By'.Email=User().Email || varAdmin ) "Date" )

Try to avoid using If's in your formulas for Items.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

That did not work. Is there a reason why I should not use a If statement in Items property?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Yes, it can quickly cause schema issues for the editor and it also doubles your work in most cases.

What about the formula did not work?

You can also consider (because many times the letter case of User().Email is different than the letter case of the SharePoint users) the following formula:

SortByColumns( Filter('Big Ideas Tool', StartsWith('Created By'.Email, User().Email) || varAdmin ) "Date" )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I tried it multiple times and its still giving me this error.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Please scrub through the formulas I provide as I type them by hand without the aid of a design editor...there is a comma missing. Should be:

SortByColumns( Filter('Big Ideas Tool', StartsWith('Created By'.Email, User().Email) || varAdmin ), "Date" )

Was this reply helpful? Yes No