cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

how to Insert Date values in SQL table from excel

Hi Mates,

we have date values in excel, we need to insert in to table 

i just created a compose for assign excel field , then next compose formatted like formateDateTime(outputs('compose')) but it throws error like can not format, 

if this is not right way ..!

i also tried with variable(initial : string)

then set variable i could not see any excel column at Dynamic content to map like excel column formateDateTime(exceldatefield,'mm/dd/yyyy')

Any help please

Any help please 

1 ACCEPTED SOLUTION

Accepted Solutions

@muralikrishna12 

 

Please give a try with the following expression:

 

if(greater(length(outputs('Compose')),0),addDays('12-30-1899',int(outputs('Compose')),'MM-dd-yyyy'),null)
 
Please let me know if you have any more questions.
 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

View solution in original post

4 REPLIES 4
ManishJain
Solution Sage
Solution Sage

Hi @muralikrishna12 ,

 

Please refer to similar threads to handle excel dates in MS Flow:

 

https://powerusers.microsoft.com/t5/Using-Flows/Convert-excel-numerical-dates-to-date-MS-FLOW/td-p/4...

 

Thanks

Hi Mates,

working fine with when excel date field don`t have blank only, but what if we have row has blank value..?

 

addDays('1899-12-30',int(output('compose'),'yyyy-MM-dd')

 

i can convert and insert date values, when value is there in excel

what if excel has blank  it should should not stop, it should iterate with next values.

any help here if no value then it should blank, else update with excel value

 

@muralikrishna12 

 

Please give a try with the following expression:

 

if(greater(length(outputs('Compose')),0),addDays('12-30-1899',int(outputs('Compose')),'MM-dd-yyyy'),null)
 
Please let me know if you have any more questions.
 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Hi @rsaikrishna 

thank you...! its working charming, thanks for saving my time.

 

Closing this issue now.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,835)