cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
voglejm
Helper I
Helper I

Filtering with Date Picker, Text Search, and IsBlank

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

21 REPLIES 21

@voglejm ,

Yes, dates are not a Delegable filter, but as you said you were getting a result when a date was chosen, I figured this was not an issue for you and was not going to take you down the collection track unless it was necessary.

To your question - clear the Default of DatePicker1 (if you have not already done so) and put

Reset(DatePicker1)

on the end of your code.

 

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.

Hi @voglejm ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

 

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.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (1,830)