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

Highlighted
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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,172)