Answered

Filter Gallery for Overdue button

(0) Share

Report

Posted on by frank90

Hello Community,

I created a container that has Button gallery to filter assigned assets based All, Permanent, Temporary& OverDue.

All filters by all Assets

Permanent filters by Permanently assigned assets. --choice column named Status

Temporary filters by temporary assigned assets ---choice column named Status

Overdue filters by assets past their ReturnDate (a SharePoint column).

I can successfully filter my gallery with the All, Permanent and Temporary buttons. am having a challenge filtering Overdue button.

I want the OverDue button to check status column for temporary assets and also the ReturnDate column and then filter those assets that are past their Due date.

The code for Items of the Buttons gallery :

Table({varFilter:"All"},{varFilter:"Permanent"},{varFilter:"Temporary"},{varFilter:"OverDue"})

This is the code of the main gallery under Items on which i make my filters which are successful.

If(TabsGallery.Selected.varFilter="All ",'Asset Register',Filter('Asset Register',Status.Value= TabsGallery.Selected.varFilter))

I need help to add the OverDue functionality to this filter query.

You can also suggest new functionality for both the buttons and filter codes.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @frank90 ,

Does the OverDue mean that ReturnDate is less than today?

If so, please try this.

Switch(TabsGallery.Selected.varFilter, "All ", 'Asset Register', "Permanent"||"Temporary", Filter('Asset Register',Status.Value= TabsGallery.Selected.varFilter), "OverDue", Filter('Asset Register',Status.Value="Temporary"&&ReturnDate<Today()))

Best regards,

Rimmon

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @frank90, 😊

Adjusting the Filter condition slightly allows us to avoid the If statement. The code below will:

Apply no filter when 'All' is selected

Filter based on status 'Permanent' in case that is selected - otherwise filter based on 'Temporary'

Apply an additional return date filter in case OverDue is selected (only return records past the Return Date)

Filter( 'Asset Register', //Either all is selected TabsGallery.Selected.varFilter = "All" || //Or filter based on status (overdue also being permanent) ((TabsGallery.Selected.varFilter = "Permanent" && Status.Value = "Permanent") || (TabsGallery.Selected.varFilter <> "Permanent" && Status.Value = "Temporary")), //If OverDue is selected, add additional filter checking for records with an overdue return date TabsGallery.Selected.varFilter <> "OverDue" || ReturnDate < Today() )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
frank90 43 on at

Like (0)

Report
Copy link

Link copied!

When i run the app, the permanent button returns " All Assets" instead of the Permanent assets only. But the Overdue functionality is working.

Was this reply helpful? Yes No
frank90 43 on at

Like (0)

Report
Copy link

Link copied!

this is the error I get with the Switch function.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @frank90,

Thanks for the feedback, adjusting '(Status.Value = "Temporary")' to '(TabsGallery.Selected.varFilter <> "Permanent" && Status.Value = "Temporary")' should do the trick.

I have adjusted my previous code accordingly. Below an alternative version using an If function:

If( TabsGallery.Selected.varFilter = "All", 'Asset Register', TabsGallery.Selected.varFilter = "Permanent" || TabsGallery.Selected.varFilter = "Temporary", Filter('Asset Register', Status.Value= TabsGallery.Selected.varFilter), TabsGallery.Selected.varFilter = "OverDue", Filter('Asset Register', Status.Value= "Temporary" && ReturnDate < Today()) )

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @frank90 ,

So, where does the error appear in the code?

Best regards,

Rimmon

Was this reply helpful? Yes No
frank90 43 on at

Like (0)

Report
Copy link

Link copied!

This works 🙂. Thank you @LaurensM

Was this reply helpful? Yes No