Power Platform CommunityForums Power Automate - Power Automate Desktop Using variable when sa...

Using variable when saving file in the file name

Like (0) Share

Report

Posted on 24 Jan 2025 09:58:22 by CU24010951-0

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:

Process Advisor

All responses (1)

Answers (0)

Suggested answer

eetuRobo 3,268 Super User 2025 Season 1 on 25 Jan 2025 at 05:43:24

Like (0)

Report

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