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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,911)