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:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

There are quite a lot of threads around this. Have a look at this

https://powerusers.microsoft.com/t5/Building-Flows/Excel-Table-cannot-convert-value-43875-4825115739-to-type/m-p/477360#M58248

Thanks

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

Like (1)

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
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

You could use empty, length, null checks in Power Automate using IF condition. Add an IF condition to check against the column or compose to determine whether its null or length > 0 etc.

Thanks

Was this reply helpful? Yes No

Verified answer

rsaikrishna

3,703 on at

Like (1)

Report

Copy link

Link copied!

@Anonymous ,

Please try the below 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 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

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

The expression you can use the one which we discussed yesterday as in one IF expression then again if you have more than one action steps to use better to use an IF condition as an action step.

If you have any questions let me know.

Thanks

Was this reply helpful? Yes No