cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Steffijeff
Helper I
Helper I

Combine a filter and search formula

Good morning

 

I have built a PowerApp which is working beautifully but I am now trying to get around the delegable functions limitations as my list will be bigger than 2000 items eventually. My gallery is linked to a SharePoint list and I currently have the following formula which is delegable;

 

Filter('Risk Event Log','Date Notified' >= DateAdd(Today(),-400,Days))

 

I also have the following formula which allows searching via 2 dropdown boxes and a text box;

 

Search(

If(
Dropdown3.Selected.Status ="All" And Dropdown4.Selected.Category = "All", 'Risk Event Log',
Dropdown3.Selected.Status = "All" And Dropdown4.Selected.Category <> "All", Filter('Risk Event Log', Category = Dropdown4.Selected.Category),
Dropdown3.Selected.Status <> "All" And Dropdown4.Selected.Category = "All", Filter('Risk Event Log', Status = Dropdown3.Selected.Status),
Dropdown3.Selected.Status <> "All" And Dropdown4.Selected.Category <> "All",
Filter('Risk Event Log', Category = Dropdown4.Selected.Category And Status = Dropdown3.Selected.Status)),
TextInput1.Text, "ExternalReference")

 

Both formulas work perfectly in isolation but I need to combine them. So I need the list to be filtered first and foremost so only items within the last 400 days pull through to the app and then we can search those items via the dropdowns and text box.

 

I've tried lots of options, viewed loads of posts and I just can't get over the line. Please tell me this is possible......

 

Thank you

Steph

10 REPLIES 10
Steffijeff
Helper I
Helper I

@WarrenBelz thank you sooooo much. I tweaked it slightly as the sort on its own is enough for what I need so I didn't need the 400 days piece but it's perfect!! Thank you again 🙂

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,405)