cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Search with date field

Hello

How can i use Search with a date field and datepicker

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff murali
Power Apps Staff

Re: Search with date field

Search function works with Text fields.

 

https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

 

You need to use Filter/LookUp in your case.

 

Filter(MyDataSource, DateCol = DatePicker1.SelectedDate)

 

Thanks
Murali

View solution in original post

4 REPLIES 4
Power Apps Staff murali
Power Apps Staff

Re: Search with date field

Search function works with Text fields.

 

https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

 

You need to use Filter/LookUp in your case.

 

Filter(MyDataSource, DateCol = DatePicker1.SelectedDate)

 

Thanks
Murali

View solution in original post

Anonymous
Not applicable

Re: Search with date field

Thanks !

quentinfr
Level: Powered On

Re: Search with date field

Hi,

I have an issue with your solution. it works when I do Filter(MyDataSource, DateCol = today())  (I have the blue dot suggestion but it is not an issue for the moment because my dg has 20 rows) but it doesn't works when I replace today() with datepicker1.SelectedDate (no blue dot suggestion).

For information I use azure sql database.

Kind regards

Francis_Ayson
Level: Powered On

Re: Search with date field

I also use filter in powerapps with datepicker and it doesnt work. my database is a sharepoint list. when i changed it to todays date, it worked. 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (6,164)