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

Like (0) Share

Report

Posted on 22 Mar 2023 19:42:50 by SM-03042006-0

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.

All responses (2)

Answers (1)

Verified answer

Aakashch_1998 40 on 23 Mar 2023 at 10:11:04

Like (1)

Report

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)

Thanks & Regards
@Aakashch_1998
MichaelAnnis 5,721 Super User 2025 Season 1 on 22 Mar 2023 at 21:23:16

Like (1)

Report

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!