News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Writing current date a...

Power Automate - Building Flows

Answered

Writing current date as Excel sheet name

(0) Share

Report

Report

Posted on by dwalker97

82

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:

Business Process Flows

All responses Img

All responses (2)

Answers Img

Answers (1)

dwalker97 82 on at

Like (0)

Report

Re: Writing current date as Excel sheet name

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

fchopo 7,972 Super User 2025 Season 1 on at

Like (1)

Report

Re: Writing current date as Excel sheet name

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans