Hi everyone,
I'm trying to get the current week number in Power Automate (cloud), but I keep running into issues with invalid expressions. I tried using but all are wrong
formatDateTime(utcNow(), 'ww') = semaine "ww" (wrong)
add(div(dayOfMonth(utcNow()),7),1) = semaine 3 (wrong)
add(div(dayOfMonth(utcNow()),7),0) = semaine 2 (wrong)
add(div(dayOfYear(utcNow()),7),1)= semaine 2 (wrong)
However, this doesn't seem to work as expected. It either returns "ww" as text or causes an error.
Does anyone know the correct expression to get the current week number in Power Automate? Ideally, I want a simple and reliable solution that works within a Compose action.
I ask ChatGPT et Copilot to help me but they didn't find (i try youtube too but the same thing, nothing works)
Thanks in advance!
=WEEKNUM([@Date];25)
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional