Microsoft Power Platform Power Automate

Creating dynamic CSV-Output from Flow

In a project we implemented a technical workaround to get dynamic content from several SharePoint lists and merge that content in a CSV-Output.


Here are the steps implemended in the flow

1. Create a string variable that contains the csv output and initialize the header information


init csvOutput header line

2. Query items from the first data source (in our case a SharePoint list) using the SharePoint Get Items flow action

3. To insert data in the csv string variable in the predefined column order use the Data Operations -  Select action


Select items from list

4. Convert the output from the selected action into a csv file. After that extract the lines ignoring the header info and ignoring the empty line at the end of the csv output.


5. repeat steps 2 till 4 to enrich the content of the csv output string variable with content from other data sources

6. replace the placeholders in the csv output string with the right line delimiters used in PowerApps and return the output string