Multiple Filter Gallery - Canvas App

[AadilAhmed]

Hey Everyone,

I'm trying to get multiple filter condition on gallery based on a selection from a dropdown.

So I have a galley and a drop down. And SharePoint list is the data source. In that list we have a column named status which is a choice column and has multiple options. So I need to filter the List on the Status Column

So if the first option in the drop down is selected I need to filter the SharePoint list and show the result in the gallery. And my filtering condition is (i.e. if the first option is selected)

Where Status equals to:

• Awaiting for Review
• Under  Review
• Fulfilment Error
• Fulfillment Error Under Review
• Forwarded  for Fulfillment

OR Requests with Status is either Submitted OR  In Progress AND Submit Date older than 1 day

OR Requests with Status Approved AND Decision Date older than 1 day

All of this should be done in a single filter. If I select the first option the result should match all the above conditions.  I have managed to filter all the bulleted points , I'm only having trouble in the last two lines of the condition.

Can anyone help me with this, how to write a single filter query and cover all this conditions? If not is there a workaround.

And don't worry about the Day calculations, I got that covered.

Thanks

[WarrenBelz]

HI @AadilAhmed ,

Pease share the code (in Text) you have written to date

[AadilAhmed]

Here you go @WarrenBelz 

This is the filter query written in a If condition if the first option is selected from the drop down (Query written in items property of Gallery)

Filter('LIST NAME HERE',Status.Value = "Awaiting for Review" || Status.Value = "Under Review" || Status.Value = "Fulfilment Error" || Status.Value = "Fulfillment Error Under Review" || Status.Value = "Forwarded  Fulfillment")

And to calculate no. of days

'Submit Date'= DateAdd(Today(),-1,Days)

[WarrenBelz · Accepted solution]

@AadilAhmed ,

Syntax guidance below - free-typed so watch commas/brackets etc.
Note the With() statement is to avoid Delegation issues.

With(
   {
      wDay:
      DateAdd(
         Today(), 
         -1,
         Days
      )
   },
   Filter(
      'LIST NAME HERE',
      (
         Status.Value = "Awaiting for Review" || 
         Status.Value = "Under Review" || 
         Status.Value = "Fulfilment Error" || 
         Status.Value = "Fulfillment Error Under Review" || 
         Status.Value = "Forwarded  Fulfillment"
      ) ||
      (
         (Status.Value = "Submitted" || Status.Value = "In Progress") &&
         'Submit Date' < wDay
      ) ||
      (  
         Status.Value = "Approved" && 'Decision Date' < wDay
      )
   )
)

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.

Visit my blog Practical Power Apps

[AadilAhmed]

Thank you so much.. i will try this out and will let you know.. Again thanks for all your help

[AadilAhmed]

Worked perfectly, thanks!!