Filtering dataverse table to show empty values

[user391_]

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. 

[cha_cha · Accepted solution]

Hello @user391_ 

How about trying this:

Filter(
        'APM Parking Spaces',
        'Allocated To Monday'.'APM Group' = gblRecBookingFor.'APM Group'.'APM Group'  || IsBlank('Allocated To Monday'.'APM Group')
    )

[user391_]

Thanks, that has seemed to work

[user391_]

Thanks, that has seemed to work