cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thunter
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
Drrickryp
Super User II
Super User II

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (32,613)