Using dynamic name in Copy file

[gvg1]

Hi folks,

I am building a flow that copies some file in the same Sharepoint folder. My problem is that the name of the file to be copied differs from month to month. I tried to build a variable before the Copy file step (formatDateTime(utcNow(), 'MM')) to be used as dynamic content to build my file name aka "Sales 2022-08.xlsx" but I am struggling to provide correct string in the "File to Copy" part. I use this syntax to build dynamic file name but it doesn't seem to work. Instead of value "2022-08" to be inserted into the file name I get that formatDateTime formula :

How do I correctly build the dynamic name? Tried without single quotes, tried using "&" for concatenation - nothing works. Googled a lot without any success.

Thanks for any tips.

[Rhiassuring]

Hi there, 

You'll want to use concat() as an expression, using the expression tab which is to the left of your dynamic content tab

@manuelstgomes has a great blog post on how this can be used:

https://manueltgomes.com/reference/powerautomate-function-reference/concat-function/