Answered

String Query Filter in URL get Unfiltered Gallery Items from SharePoint List

(0) Share

Report

Posted on by serviceflow

Hello!

I currently have Column in SP list called Departmet_Division which if assign Var=DEPT in the URl. Department_Division is a choice column and so if I enter the app address and append with "DEPT=Doors" the app serves up a filtered list of items where Department_Division is = "Doors". There are roughly eight possible choices for Department_Division value that correspond to eight different prefilter views via URL. I have another Column called "OpenComplete" with choice either "Open" or Complete" and set on gallery to only show "Open" items.

Want to essentially get all items that are "Open" via URL string Param. Another way to think about this is to get all all items if DEPT = any value.

Example of appended url is something like this:

&DEPT=Doors

&DEPT=Doors%20and%20Panels

Can anyone help?

I tried combining multiple values fo the 'DEPT=' and listing multiple values but not working....there must be a way to assign a value for DEPT= "All" or DEPT= Show all DEPT's.

Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
wherever you are using this param, have a condition for an ALL value, then pass ALL in as the param

like

Filter( DatasourceName, Param(DEPT)="All" || Department = Param(DEPT) )

This is pseudo code so you'd have to change it to work with your own formula, but that is how I would do it, have wherever you are currently showing the items filtered based on a condition that checks for a specific value, which if true wont filter by DEPT, but if false then filter department by the param.
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Sort( Filter( '_Corrective Action_', VarDepartment.Value = "ALL" || Department_Division.Value = VarDepartment.Value, BU.Value = VarBU.Value Or IsBlank(VarBU), 'Functional Area'.Value = VarFA.Value Or IsBlank(VarFA), OpenComplete.Value = "Open" ), BU.Value, Ascending )

When you want all items to show, just pass ALL in the URI, it doesn't need to be an actual value, we are just checking whether the param is equal to that , if yes then dont filter by department, Or (||) else filter by department - so it will only filter when the department is set to an actual department value.