Function for year and week number dynamically

(0) Share

Report

Posted on by jeongkim

Hi,

Pls help what causing the error.

My ideal result is:

'TOSS Site Progress Report_2025_W13.xlsx'

concat(year(convertFromUtc(utcNow(),'Korea Standard Time')), '_W', weekOfYear(convertFromUtc(utcNow(),'Korea Standard Time')))

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report
You can do this in one expression, but I've split it out so it's easier to read.

Compose 1 (Date Now):

convertFromUtc(utcNow(),'Korea Standard Time')

Compose 2 (Add WK Num)

concat( 'TOSS Site Progress Report_', formatDateTime(outputs('Date_Now'),'yyyy'), '_W', formatNumber( add(div(dayOfYear(outputs('Date_Now')),7),1), '00' ), '.xls' )

Result:

Was this reply helpful? Yes No
jeongkim 45 on at

Like (0)

Report

it works thanks!

Can you also show me how to combine 2 Composes into 1 action pls?

Was this reply helpful? Yes No
CU26032143-0 2 on at

Like (0)

Report
The two composes as one compose/action is:

concat( 'TOSS Site Progress Report_', formatDateTime(convertFromUtc(utcNow(),'Korea Standard Time'),'yyyy'), '_W', formatNumber( add(div(dayOfYear(convertFromUtc(utcNow(),'Korea Standard Time')),7),1), '00' ), '.xls' )

Don't forget to mark as solved!

d(-_-)b

Was this reply helpful? Yes No
Suggested answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report
Sorry, I replied under a different account.
Still the same answer though

The two composes as one compose/action is:

concat( 'TOSS Site Progress Report_', formatDateTime(convertFromUtc(utcNow(),'Korea Standard Time'),'yyyy'), '_W', formatNumber( add(div(dayOfYear(convertFromUtc(utcNow(),'Korea Standard Time')),7),1), '00' ), '.xls' )

Don't forget to mark as solved!

d(-_-)b

Was this reply helpful? Yes No
jeongkim 45 on at

Like (0)

Report

do you think it would work if I amend like this?

Desired outputs are:

one is 'TOSS Site Progress Report_20250331'

another is 'TOSS Site Progress Report_2025_W14'

if below code is okay then how can I adjust the code you shared for Year & Week number in one action?

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report
You can produce any file name you want using the concat function:

TOSS Site Progress Report_20250331

concat( 'TOSS Site Progress Report_', formatDateTime(convertFromUtc(utcNow(),'Korea Standard Time'),'yyyyMMdd'), '.xls' )

TOSS Site Progress Report_2025_W14

As per the solution provided

Was this reply helpful? Yes No
jeongkim 45 on at

Like (0)

Report

Thanks I got desired outputs!

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

@jeongkim

OK Good!
Don't forget to mark solution as accepted

d(-_-)b

Was this reply helpful? Yes No