I have a gallery and i'm trying to give users several ways to filter it. I have controls above the gallery to let the user select a Year, region, customer or keyword to filter on. I want to use only the filters the user has selected.
My script ends up looking like this (this represents just the conditions, not the actual filters):
After adding the actual filtering logic for each condition (and god forbid an other condition) this ends up being hundreds of lines of script that are largely incomprehensible, even to the author!
Is there a better way to do this?
What we really need is a real code editor! If i could edit this script in an intelligent VSCode editor I'd have this done in minutes. The way it is it's taking days!
Please give me back my curly braces!
Solved! Go to Solution.
Then do you believe this code would work? I ask only because I need a 2nd set of eyes on this to make sure there is no delegation error.
Filter( FPARequests, IsBlank(tbYear.Text)=true Or Year = tbYear.Text, IsEmpty(cbxRegion.Selected)=true Or Region = cbxRegion.Selected, IsBlank(tbCustomer.Text)=true Or Customer tbCustomer.Text, IsBlank(tbKeyword.Text)=true Or Keyword = tbKeyword.Text )
I am no expert, but by looking at the formula it is fine. Plus Powerapps also didn't throw in delegation error, and I assume your gallery returns more than 1 result. So you have 3 set of eyes for this formula.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!