web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sort gallery by expired

Power Apps

Answered

Sort gallery by expired

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have this gallery where i would like to show only active accounts.

I have fields with date created and expiration date (48 hours after date created)

How can i by default only show items that has not yet expired, but if the user selects "inactive" on dropdown it will show all expired accounts?

Right now, my gallery Items is like this:

Search(Filter(VikarAccessLog;OrdereEmail=varCurrentUser.Email); AktiveringsHistorikSearch.Text; "VikarName")

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try this - the With() statement is to keep it a bit Delegable

With( { wData: Filter( VikarAccessLog; OrdereEmail = varCurrentUser.Email ) }, Search( Filter( wData; ( DropdownName.Selected.Value = "Inactive" && DateDiff( Created; Now(); Hours ) > 48 ) || DateDiff( Created; Now(); Hours ) <= 48 ); AktiveringsHistorikSearch.Text; "VikarName" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks so much for the help!
It worked just like intended. Almost. 😅
Now it hides all inactive by default, but if i select the inactive on dropdown, i will still see the active accounts.

Also, i just had to change the Hours to TimeUnit.Hours and it worked flawless after.

Join the conversation