Hi, I have a gallery that filters a dataverse table that holds parking spaces and which group they belong to on a certain day - making the days of the week the columns in my data table. These columns are a lookup column. What I want to do is to be able to write a filter that filters a gallery only showing the spaces that belong to the user's group and the free spaces (the spaces that do not belong to any group).
So far, I have tried
Filter(
'APM Parking Spaces',
'Allocated To Monday'.'APM Group' = gblRecBookingFor.'APM Group'.'APM Group' && 'Allocated To Monday'.'APM Group' = " "
)
and
Filter(
'APM Parking Spaces',
'Allocated To Monday'.'APM Group' = gblRecBookingFor.'APM Group'.'APM Group' && 'Allocated To Monday'.'APM Group' = Blank()
)
Neither of these work, apart from the first half of the filter where I filter by the gblRecBookingFor (Variable holding user's group and other information).
The error that I get is "GUID values can only be compared to GUID values" on the second equal sign.
