You’re offline. This is a read only version of the page.
Hi all,
I've had an issue for a while now where dates are not being formatted correctly seeding data from Excel to Sharepoint using Flow.
In Excel, the dates are formatted as Dates however when I run the flow to seed the data, I get the following error message:
Can anyone help me fix this please? It's so frustrating as I've tried to change the date format in excel so many times.
Thanks
Hi Manish,
It's probably easier if I show you the expression I am trying to apply. For reference, 'Target Date for Upgrade or Launch' is the column name where the dates are being sourced from in Excel.
if(empty(@{items('Apply_to_each')?['Target Date for Upgrade or Launch']}),null,addDays('1899-12-30',int(@{items('Apply_to_each')?['Target Date for Upgrade or Launch']}),'yyyy-MM-dd'))
I think the problem is that Flow will not allow me to use Dynamic content within this syntax.
What do you suggest?
Many thanks
Thanks. When I tried this, it says the expression is invalid?
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
Share
Report
All responses (
Answers (
