web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : SyidYbTXwjPxabPS48DOJV
Power Automate - Using Flows
Unanswered

Incorrect Format of Dates

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2022 11:49:42 by

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: 

Gemmalouiseboe_0-1645444102380.png

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

  • MJain Profile Picture
    2,450 on 21 Feb 2022 at 17:52:30
    Re: Incorrect Format of Dates

    Hi @Anonymous ,

     

    when you use Target Date for upgrade or Launch use "_" for spaces instead.

     

    Thanks

  • Community Power Platform Member Profile Picture
    on 21 Feb 2022 at 16:29:16
    Re: Incorrect Format of Dates

    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

  • MJain Profile Picture
    2,450 on 21 Feb 2022 at 16:16:00
    Re: Incorrect Format of Dates

    Please share your flow screenshot where you applied this.

  • Community Power Platform Member Profile Picture
    on 21 Feb 2022 at 15:56:19
    Re: Incorrect Format of Dates

    Thanks. When I tried this, it says the expression is invalid?

  • MJain Profile Picture
    2,450 on 21 Feb 2022 at 14:53:12
    Re: Incorrect Format of Dates

    Hi @Anonymous ,

     

    Please use the following formula to convert that integer value to date :

     

    if(empty(<DATE TO CONVERT>),null,addDays('1899-12-30',int(<DATE TO CONVERT>),'yyyy-MM-dd'))

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete