Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Date Integer not appea...
Power Automate - Building Flows
Answered

Date Integer not appearing as an Output

(0) ShareShare
ReportReport
Posted on by Socrates 64

Like many I've had the issue where dates in Excel online appear as integers - fine, I can deal with this, but the dates themselves aren't appearing in any outputs and are just null.
 
To test, after I grab my table via 'List Rows in a Table', I've created a condensed CSV table with the date and the next row along:

 

Annotation 2020-09-02 153051.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You can see a date has been pulled through ("44013") as an input, as well as the next row ("6 months") - but when it comes to the Outputs it's not there. So I can't acutally use it at all.

 

What am I missing?

 

 

  • Verified answer
    Socrates Profile Picture
    Socrates 64 on at
    Re: Date Integer not appearing as an Output

    Ok @v-alzhan-msft I seem to have (finally) gotten to the bottom of it.

     

    (All) my date columns had the string "(DD/MM/YYYY)" included in the column header - PA did not like this. Picking the header from the dynamic content or using its 'true' name inserted manually did not make a difference. 

     

    I removed (DD/MM/YYYY) from the header and the date/integer was passed through as an Output.

     

    I'm not sure why this is the case (and would be interested if anyone knows a workaround if I were not able to rename the header) but I guess my problem is nominally solved.

     

    Thanks for acting as a sounding board!

  • Socrates Profile Picture
    Socrates 64 on at
    Re: Date Integer not appearing as an Output

    Hi @v-alzhan-msft 

     

    At the moment there's not much to it as I'm running into this problem. It is as below:

     

    image.png

  • v-alzhan-msft Profile Picture
    v-alzhan-msft on at
    Re: Date Integer not appearing as an Output

    Hi @Socrates ，

     

    Could you please share a full screenshot of the configuration of the flow?

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans