Skip to main content

Notifications

Community site session details

Community site session details

Session Id : KtIZbxQqhEzLtgD5Gija1a
Power Automate - Power Automate Desktop
Suggested answer

Using variable when saving file in the file name

Like (0) ShareShare
ReportReport
Posted on 24 Jan 2025 09:58:22 by
Hi
I have a workflow where I extract data and want to save each data object into its own excelfile. 
So I have a Variable FileName and want to use it when I save my excel file. I have tried to search around and understod I should have the file path as "C\Excel folder\%FileName%.xlsx"

Problem I get is that the excel file is save as %FileName% instead of the value of the variable. How should I write the document path to get the value of the variable into the file name?


 
 
Categories:
  • Suggested answer
    eetuRobo Profile Picture
    3,419 Super User 2025 Season 1 on 25 Jan 2025 at 05:43:24
    Using variable when saving file in the file name
    %variableName% -syntax is in default PAD flows. You are using Power Fx enabled flows. Power Fx never uses percent signs for variables.
    For Power Fx it either =VariableName or ${VariableName}

    In your case use the following: C:\Excel Extract\${FileName}.xlsx

    I recommend using the PADs "Select variable" option to get the correct syntax. So put the cursor where you want the variable to be and click the variable icon and then select the correct variable


     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 147 Super User 2025 Season 1

#2
Riyaz_riz11 Profile Picture

Riyaz_riz11 54 Super User 2025 Season 1

#3
Nived_Nambiar Profile Picture

Nived_Nambiar 30 Super User 2025 Season 1

Overall leaderboard
Loading started