web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Help - How to get last...

Power Automate

Unanswered

Help - How to get last week's number from date in Power Automate?

(1) Share

Report

Report

Posted on by CU10021113-0

11

Help - How to get last week's number from date in Power Automate?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @CU10021113-0,

You can calculate it with an expression. Ryan Maclean has for example shared a blog about this.

https://ryanmaclean365.com/2020/04/29/calculating-iso-8601-week-number-for-dates-in-power-automate/

In your case you want to change that expression to sub 1 week from the UtcNow (Today's date).

Below is an example based on ISO 8601 week numbers

That should return 6 today

sub(div(add(dayofyear(addDays(subtractFromTime(utcNow(), if(equals(dayofweek(utcNow()),0),6,sub(dayofweek(utcNow()),1)), 'Day'),3)),6),7), 1)

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Suggested answer

CU10021113-0 11 on at

Like (1)

Report

Thank you very much, solve my problem!

Was this reply helpful? Yes No

Join the conversation