cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Filter DataTable between Dropdown and 2 Date Pickers

I am trying to Filter a DataTable by using a Dropdown and 2 Date Pickers. So I have a SQL table that has two columns named TruckNumber and DateTime. I want the DataTable to filter by the TruckNumber selected and to be between the Start Date and End Date picked. I keep getting error "Service call was successful. However, there was a problem processing the server response." I have refreshed my Datasource but that did not help. See screenshot below. Thank you!

map1.png

1 REPLY 1
Highlighted
Super User III
Super User III

Hi @thunter 

I don't use SQL but one of the problems that I have seen is that the format of the SQL date fields are incompatible with PowerApps datetime fields.  One solution I have seen is to use the Text() function to convert them all to the same format, say ShortDate in your formula. To test it , put a label on your screen with the Text property DateTime and do the same for StartDate.Selected.Date and see if they are identical.  Then use Text(DateTime, ShortDate) and Text(StartDate.Selected.Date, ShortDate).  If they match try that in your formula.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

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