Skip to main content

Notifications

Community site session details

Community site session details

Session Id : alBPeT+wLsSYiC66C42bvb
Power Automate - Power Automate Desktop
Answered

Extract Month, Day, and Year from Excel table in Power Automate DESKTOP

Like (0) ShareShare
ReportReport
Posted on 22 Mar 2023 19:42:50 by 28

I can read a date from a table in Excel and convert using "Convert text to datetime" to produce a variable, but need to find the day, month and year so I can populate a custom date picker.  I have found solutions for cloud flows, but not for a desktop flow.

  • Verified answer
    Aakashch_1998 Profile Picture
    40 on 23 Mar 2023 at 10:11:04
    Re: Extract Month, Day, and Year from Excel table in Power Automate DESKTOP

    Hi @RedCoatinOhio1 

    You can fetch Day, Month ,Year from Output Variable Property (Output variable of Convert Text to Datetime Action)
    Screenshot (7).png

     

    Thanks & Regards
    @Aakashch_1998 

  • MichaelAnnis Profile Picture
    5,721 Super User 2025 Season 1 on 22 Mar 2023 at 21:23:16
    Re: Extract Month, Day, and Year from Excel table in Power Automate DESKTOP

    After converting text to datetime, you can convert datetime to text and make a different variable for each one:

     

    So, if datetime is 3/1/23, all the convert to text would be the following:

    yy=23

    yyyy=23

    M = 3

    MM = 03

    MMM = Mar

    MMMM = March

    d = 1

    dd = 01

     

    Good luck!

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 the Engage with the Community forum!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 108 Super User 2025 Season 1

#2
CU12050101-0 Profile Picture

CU12050101-0 22

#3
Nived_Nambiar Profile Picture

Nived_Nambiar 20 Super User 2025 Season 1

Overall leaderboard
Loading complete