Creating new sheets with each flow run

[OllyMUK]

Hi all

I need to create a new sheet in the same spreadsheet each time the flow runs (once per week). It needs to have an obvious name such as "Friday 29th Jan 2021"

However the Name property of the Create Worksheet module doesn't allow for the use of formatDateTime functions. 

Any ideas how I can achieve this?

Olly

[Pstork1]

If you insert the formatdatetime formula using the Expressions tab of the dynamic content you can definately use that function to name the worksheet.  The following formula should be close to what you want

formatDateTime(utcNow(),'dddd dd MMM yyyy')