Filter and display Null Values from Gallery

[TechNewbie]

Hi, I am new to PowerApps and trying to create a simple room booking tool.
 
I am trying to filter based on gallery results.  My filter is limited in showing only timeslots which are already booked,
I would also need to show all other available timeslots. Apologies for the basic question. Can you please advise how I can filter it correctly? Can I use the Isblank command to return a value? I have attached the sample screenshots and the filter query that I used. Thank you!
 

 

[Drrickryp]

Hi @TechNewbie 

If you are looking to find a single record you would use !IsBlank().   If you are filtering for all records meeting a certain condition you would Filter using !IsEmpty(). This results in a table meeting the filtered conditions.  Please see the documentation for an explanation of the difference and some examples. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty

[v-yutliu-msft · Accepted solution]

Hi @TechNewbie ,

Could you describe more clealy about what formula that you are confused about?

Or you could show me screenshoots that you have problem.

If you are confused about the IsBlank function, let me explain it.

It is used to justify whether the value is empty value.

If it is empty value, the result is true, or else the result is false.

For examle: If(IsBlank(variable),1,2)

If varaiable is empty value, the formula will return 1, or else will return 2.

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty

Best regards,

[TechNewbie]

Thank you so much @v-yutliu-msft.

This is what I needed!