cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TechNewbie
Level: Powered On

Filter and display Null Values from Gallery

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!
 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter and display Null Values from Gallery

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Filter and display Null Values from Gallery

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

Community Support Team
Community Support Team

Re: Filter and display Null Values from Gallery

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

TechNewbie
Level: Powered On

Re: Filter and display Null Values from Gallery

Thank you so much @v-yutliu-msft.

 

This is what I needed! Smiley Happy

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,151)