Hello @Jay466
There is no easy way in Power Automate to format/calculate week number. I think you will calculate it on your own. I have a working calculation but I really hope there is a better way of doing it.
concat(take(outputs('Compose_Filename_In'), lastIndexOf(outputs('Compose_Filename_In'), '.')), formatNumber(add(add(div(sub(dayOfYear(utcNow()),1),7), if(contains(createArray(1,2,3,4),dayOfWeek(concat(take(utcNow(),4), '-01-01'))), 1 ,0)), if(less(int(replace(string(dayOfWeek(utcNow())),'0', '7')),int(replace(string(dayOfWeek(concat(take(utcNow(),4), '-01-01'))),'0', '7'))), 1, 0)), '00'), '.', last(split(outputs('Compose_Filename_In'), '.')))
This formula will calculate the first week as 00 if it starts before Thursday. I think this is better because otherwise you have 2- weeks with the number 52 or 53 and will get a file already exists error. But since you run this every Monday you won't recognize it.
You will have to change "outputs('Compose_Filename_In')" to your actual file name.
If it is not necessary to calculate the week numbers correctly, the formula could be way less complicated because you could just divide the number of days in this year by 7. That is something you have to check on your side.
Hope someone finds a better solution.
