Unanswered

Expression for Week Number

(0) Share

Report

Posted on by KE-02101151-0

Hi There,

I am willing to create a flow to send weekly e-mails to certaion people with current weeknumber information on subject, which should be changing every week.

I have been able to add current date to subject with a simple expession utcNow(), but couldn't figure out the right expession for current week number.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Srini007 3,467 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can try as below

If I have answered your question, please mark it as the verified answer. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No
abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is the week based on the actual calendar week, a week that the company designates as the first week (for example, first week with a Sunday in it, or the Project week?

In 30 years, I've never had code that just needed the simple calendar week, so that's why I asked.

Was this reply helpful? Yes No
Chriddle 8,686 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The formatDateTime() function does not have a date format string of "ww" nor (as far as I know) any other "easy" way to determine the week number.

Here I show a flow that caluculates the week number of a date according to ISO 8601 :

https://community.powerplatform.com/forums/thread/details/?threadid=d5354cfe-2776-4af1-bef8-aee3294f3de4

Was this reply helpful? Yes No