Power Platform Community Forum Thread Details

Hi,

I am trying to patch date picker control in PowerApps to datetime field in SQL (). But I am receiving HTTP 400 error while submitting the data to SQL. Format of datetime field in SQL - 2021-02-18T19:58:45.507

We are using custom connector to connect to SQL from PowerApps and this is the formula I am using to submit the data for date picker control.

CQPortalBackEndAPI.CreateClient({client_calendar_start_date:client_calendar_start_date.SelectedDate})

Please let me know how to patch the date picker control to SQL

Thanks,

Categories:

Building Power Apps

Hi,

Not sure this answers your question but I can confirm that the SelectedDate Field is valid for SQL, certainly when the column is just Date in SQL. We used to set time too but due to the good old 1 hour +/- and it wasn't needed, we decided to take the time out of the equation. As in some cases we were adding 1 hour to the Patch but that would not always be valid but I digress.

My point on the last bit above, is that it should still be valid for time wise scenarios too. However you might want to try a Now() or Today() just to see if they work.

It might also be worth trying to patch by way of the Microsoft SQL connector if possible, again just to see if you can point to it being an issue with the Custom Connector.

Other things to check that I have known needing to be manipulated to help this cause are the Date Time Zone and Format Settings.