Steve Garbett
3
Help Needed with Filtering
Help Needed with Filtering
Hi all
I need help with applying a filter to a gallery. There are quite a few criteria i want to apply and cant seem to quite get the syntax correct. My current code is as follows:
Filter(
[@'FLT Requests'],
Location = "WS" And TruckType = "Combi" And Completed = false And Allocated = false Or Allocated = true And AllocatedTo = "WS-Combi1"
),
I need to show all the requests for the specific location and truck that are open BUT ALSO ones that the driver has provisonally picked up as next jobs. This code shows all records and i cant seem to find the correct way of constructing the filter
Any help would be appreciated
3
6 comments
Public group
A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!
Leaderboard (30-day)
powered by