cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanket_powerapp
Frequent Visitor

Not able to upload Date-Time data to SQL using Flows

Trying to update SQL data using 'Execute SQL query', fields are getting updated, except fields which have data type as Datetime.

for these fields Dates like 1/1/1900 or other random dates with year 1894 are getting stored.

Parameters are coming from Powerapps.

2 REPLIES 2
v-alzhan-msft
Community Support
Community Support

Hi @sanket_powerapp ,

 

Would you please share a screenshot of the flow so we could make a test on the issue and provide a proper workaround for you?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

Attaching screenshot,

In execute query

for issue date I have used converttoutc function which converts parameter coming from powerapps to UTC

and for expiry date I have used parameter coming directly from powerapps (both parameters are coming from datepicker)

 

query.png

 

After execution I get:

query2.png

But in database issue date stored is: 6/27/1894 5:21 AM
and expiry date is: 1/1/1900 5:21 AM.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,987)