Answered

how to Insert Date values in SQL table from excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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/408590

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Verified answer

rsaikrishna

3,703 Microsoft Employee on at

Like (0)

Report

Copy link

Link copied!

@Anonymous

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 Solution. Marking 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.

Was this reply helpful? Yes No

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Closing this issue now.

Was this reply helpful? Yes No