Answered

Writing current date as Excel sheet name

(0) Share

Report

Posted on by dwalker97

I am trying to create an Excel worksheet and write the current date as the sheet name.

I am using the formula to get today's date: formatDateTime(utcNow(), 'yyyy-MM-ddThh:mm:ss'), in a Compose, and then writing the output to a variable 'Date'.

I then use a create worksheet and use the 'Date' variable as the Name selection for the worksheet.

I am getting the following error though -

Can anybody help me with this? Thanks 😊

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report

Hi @dwalker97

An Excel's sheet name can't contain special characters like: /, \, *, : , [], : Worksheets: Naming Conventions – The Excel Codex

In your case, you have the ":" character, so your flow is going to fail. Can you replace ":" by "_", for example?

Hope it helps!

Ferran

Was this reply helpful? Yes No
dwalker97 82 on at

Like (0)

Report

That works perfect, thank you! I knew it would be something minor. 😅

Was this reply helpful? Yes No