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?
%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
1 people found this reply helpful.
Was this reply helpful?YesNo
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.
Share
Report
All responses (
Answers (
4,220
