Answered

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

(0) Share

Report

Posted on 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.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

MichaelAnnis 5,727 Moderator on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Verified answer

Aakashch_1998 40 on at

Like (1)

Report

Hi @RedCoatinOhio1
You can fetch Day, Month ,Year from Output Variable Property (Output variable of Convert Text to Datetime Action)

Thanks & Regards
@Aakashch_1998

Was this reply helpful? Yes No