You’re offline. This is a read only version of the page.
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
Hi @rsaikrishna
thank you...! its working charming, thanks for saving my time.
Closing this issue now.
@Anonymous
Please give a try with the following expression:
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. |
Hi Mates,
working fine with when excel date field don`t have blank only, but what if we have row has blank value..?
Share
Report
All responses (
Answers (
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
Hi @Anonymous ,
Please refer to similar threads to handle excel dates in MS Flow:
Thanks
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
