Derive month and year of last day of prior month in filename

(0) Share

Report

Posted on by nich3play3r

249

Hi.

New to Power Automate and have a Power BI PDF export to SharePoint cloud flow I'm working on. Last bit I can't seem to overcome is getting the year and month values for the prior month in a function for the file name. So, I'm after:

Goal progress as of [month name of prior month], [year of last day of prior month].pdf

I can get the month with getPastTime(1,'month','MMMM'), but I'm having trouble working out how to get the YYYY value from the last day of the prior month.

Thanks a lot for any pushes you can give!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @nich3play3r

Are you just looking for getPastTime(1,'month','MMMM yyyy')?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
nich3play3r 249 on at

Like (1)

Report

Yes, apparently. 😖 My date format was including hyphens, which it seems was my undoing. Thanks very much, @DamoBird365 . Really appreciate you taking the time to answer here.

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @nich3play3r

No probs. Forgot to mention I did a post on date string manipulation here https://www.damobird365.com/formatdatetime-and-formatting-a-string-date/

If you want a hyphen you could just combine two expressions.

Goal progress as of @{getPastTime(1,'month','MMMM')}-@{getPastTime(1,'month','yyyy')}.pdf

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
nich3play3r 249 on at

Like (0)

Report

So, I know getpasttime is running off UTC. If I run my flow at 10:30 pm US central time, with the code mentioned above, the value is June 2021, even though I'm still in June 2021 as I write this. Do I need to insert a step to get an adjusted version of the UTC date value for my location, or can that be incorporated in my existing function?

Thanks

Was this reply helpful? Yes No
nich3play3r 249 on at

Like (0)

Report
This seems to work:

formatDateTime(convertFromUtc(getPastTime(1,'month'),'Central Standard Time'),'MMMM yyyy')

Was this reply helpful? Yes No
hasrulhashim 4 on at

Like (1)

Report

how to get result 28 February 2022 instead of February 2022

Current formula :
getPastTime(1,'Month','MMMM yyyy') : February 2022

Was this reply helpful? Yes No
nich3play3r 249 on at

Like (0)

Report

Have you read through @DamoBird365 's very nice post here?

Was this reply helpful? Yes No