web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create an Excel file w...
Power Automate
Answered

Create an Excel file with a defined filename with a dynamic suffix in Sharepoint doclib

(0) ShareShare
ReportReport
Posted on by 31

Hi,

I have a flow that creates a monthly Excel report from a Sharepoint list to a Sharepoint document library. At the moment, my flow produces a dynamic filename using guid (as below). But what I really need is to have a defined filename like: Monthly Report As Of [dd-MMM-yyyy]. Where: Monthly Report As Of is constant and [dd-MMM-yyyy] will be dynamic based on the current Reporting month.

 

yojie_0-1632971248678.png yojie_1-1632971563664.png

 

Any suggestions on how I can accomplish this would be of great help! 🙂

 

Thank you in advance to whoever will respond to my query 🙂

 

Categories:
I have the same question (0)
  • Verified answer
    eric-cheng Profile Picture
    5,171 on at

    Hi @yojie ,

     

    You can use 

     

    @concat('Monthly Report As Of ', formatDateTime(utcNow(),'dd-MMM-yyyy'), '.xlsx')

    ericcheng_0-1632979687737.png

     

    ericcheng_1-1632979703706.png

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard