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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard