Hi - I have a gallery that currently has two dropdowns for filtering.
2. Job Status
Both of these are based on collections using data from their own separate SP lists.
I have everything working, with exception of getting the ApprovalStatus dropdown, to always have "Approved" as the selection.
The idea being that workers don't need to see tasks that haven't been approved for scheduling (basically requests that have been rejected in the first stage of the request process).
I have tried changing the 'Default' value for the dropdown to "Approved", but it resets to "All" each time I leave the screen and come back. I have tried an onVisible so that the dropdown selects "Approved", but this doesn't work also.
The selection options in the Approval Status list are:
I use a ClearCollect to bring the 'All' option in.
If working correctly, when staff look at current tasks, they will see all tasks that have been approved. They can then filter this list based on job status.
Solved! Go to Solution.
Yep @Drrickryp no worries;
If(ddApprovalStatus.Selected.AprrovalStatus = "All" And JobStatusDropDown.Selected.JobStatus = "All", WorkOrderList, JobStatusDropDown.Selected.JobStatus ="All" And ddApprovalStatus.Selected.AprrovalStatus <> "All", Filter(WorkOrderList, ApprovalStatus = ddApprovalStatus.Selected.AprrovalStatus), JobStatusDropDown.Selected.JobStatus <> "All" And ddApprovalStatus.Selected.AprrovalStatus <> "All", Filter(WorkOrderList, ApprovalStatus = ddApprovalStatus.Selected.AprrovalStatus And JobStatus = JobStatusDropDown.Selected.JobStatus) )
While this is enabling choice for the ApprovalStatus dropdown, I want it set to approved only. If there is another way to do this without using a dropdown, I am open to that suggestion too.
Thanks @PowerAddict while it isn't ideal, I have changed the collection to grab "Approved" first. It isn't a big deal though as the dropdown will be hidden anyway.
Incidentally, the LookUp option didn't seem to want to work.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT