web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering with Date Pi...
Power Apps
Unanswered

Filtering with Date Picker, Text Search, and IsBlank

(0) ShareShare
ReportReport
Posted on by voglejm 46

Hello Everyone,

My organization has asked me to create a basic app that will allow employees to volunteer to help with activities throughout the company during the COVID situation. I have a list of all available assignments and I would like the browse gallery to only show items with no support resource assigned.

 

COVID Support AppCOVID Support App

 

With help from the power apps community yesterday I was able to make real progress. Now I’m being asked to add a date picker as well. I'm able to get each of these to function separately; however, I haven't been able to successfully join the two statements into one. 

 

Date Filter

Filter(Support_Needs_List,DateValue(Text(StartDateOnly),"en")=DateValue(Text(DatePicker1.SelectedDate),"en"))

 

Text Filter

SortByColumns(Filter(Support_Needs_List,IsBlank(Support_Resource),IsBlank(FilterTextBox.Text) || FilterTextBox.Text in FacilityText),"StartDate", Ascending)

 

Any thoughts you could share would be much appreciated. The SortByColumns feature is a requirement as I only want the app to show opportunities that haven't been filled.

 

Sincerely, 

Justin

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 155,779 Most Valuable Professional on at

    Hi @voglejm ,

    If they both work now, try this

    SortByColumns(
 Filter(
 Support_Needs_List,
 IsBlank(Support_Resource) &&
 (
 IsBlank(FilterTextBox.Text) || 
 FilterTextBox.Text in FacilityText
 ) &&
 DateValue(Text(StartDateOnly),"en")=
 DateValue(Text(DatePicker1.SelectedDate),"en")
 ),
 "StartDate", 
 Ascending
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • voglejm Profile Picture
    voglejm 46 on at

    @WarrenBelz  - This is really great and exactly what I asked for. How would I go about showing everything to the user until they made a selection in the date picker? 

  • WarrenBelz Profile Picture
    WarrenBelz 155,779 Most Valuable Professional on at

    Thanks @voglejm ,

    I will try the short version here (sorry cannot test it presently) but this should work. I will also give you a shorter way of comparing the dates.

    SortByColumns(
 Filter(
 Support_Needs_List,
 IsBlank(Support_Resource) &&
 (
 IsBlank(FilterTextBox.Text) || 
 FilterTextBox.Text in FacilityText
 ) &&
 If(
 !IsBlank(DatePicker1),
 DateDiff(
 StartDateOnly,
 DatePicker1.SelectedDate,
 Days
 )=0
 )
 ),
 "StartDate", 
 Ascending
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • voglejm Profile Picture
    voglejm 46 on at

    Thanks for another quick reply @WarrenBelz . I must be doing something wrong because when I attempt to utilize this my gallery becomes blank. 

     

    4-15-2020 8-45-21 PM.png

    I change the default date from Today() to blank but the results were the same. Additionally, I removed the ! before IsBlank and received the same results. I appreciate any other insight as I'm pretty new to using the date picker. 

     

    Sincerely, 

    Justin

     

  • WarrenBelz Profile Picture
    WarrenBelz 155,779 Most Valuable Professional on at

    Thanks @voglejm ,

    Was not at my PC so free -typed it - longer version should work.

    SortByColumns(
 Filter(
 Support_Needs_List,
 If(
 IsBlank(DatePicker1),
	 IsBlank(Support_Resource) &&
 (
 IsBlank(FilterTextBox.Text) || 
 FilterTextBox.Text in FacilityText
 ),
		 IsBlank(Support_Resource) &&
 (
 IsBlank(FilterTextBox.Text) || 
 FilterTextBox.Text in FacilityText
 ) &&
 DateDiff(
 StartDateOnly,
 DatePicker1.SelectedDate,
 Days
 )=0
 )
 ),
 "StartDate", 
 Ascending
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • voglejm Profile Picture
    voglejm 46 on at

    @WarrenBelz - I'm getting the same result as I was before. The gallery is completely blank. I again removed the Default date to see if that had any impact and it didn't. Any other thoughts?

     

    Justin

  • WarrenBelz Profile Picture
    WarrenBelz 155,779 Most Valuable Professional on at

    Ok @voglejm ,

    Here is the really long version

    If(
 IsBlank(DatePicker1),
 SortByColumns(
 Filter(
 Support_Needs_List, 
 IsBlank(Support_Resource) &&
 (
 IsBlank(FilterTextBox.Text) || 
 FilterTextBox.Text in FacilityText
 )
 ),
 "StartDate", 
 Ascending
 ),
 SortByColumns(
 Filter(
 Support_Needs_List, 
 IsBlank(Support_Resource) &&
 (
 IsBlank(FilterTextBox.Text) || 
 FilterTextBox.Text in FacilityText
 ) &&
 DateDiff(
 StartDateOnly,
 DatePicker1.SelectedDate,
 Days
 )=0
 ),
 "StartDate", 
 Ascending
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • voglejm Profile Picture
    voglejm 46 on at

    @WarrenBelz - Thanks for trying. Unfortunately, I continue to get the same results, the gallery is blank and when I choose a date or type a location I'm not returned anything. It just might not be in the cards to have both functions. I appreciate all the effort though. 

     

    Justin

  • WarrenBelz Profile Picture
    WarrenBelz 155,779 Most Valuable Professional on at

    Hi @voglejm ,

    This cannot be that hard (I thought) - I have actually tested the first syntax here and got the result.
    Can you please put a label on the screen with this text

    IsBlank(DatePicker1)

     

    and see if it is true when there is no date in the control

  • voglejm Profile Picture
    voglejm 46 on at

    @WarrenBelz - Here is a screenshot. The highlighted true is the label confirming the IsBlank(DatePicker1). 

     

    4-16-2020 9-00-00 PM.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans