Create CSV table input limited

(0) Share

Report

Posted on by CAlvy

216

My flow is meant to create a CSV file in OneDrive with all the files from selected SharePoint sites.

Each file is appended to a string variable (files) in a loop. Outside of the loop I then add this string variable to a Compose action.

I use the outputs of Compose in my Create CSV table action:

json(outputs('Compose_2'))

, then create my CSV file.

When I check the outputs of Compose, I have all the files that were added to the variable in the loop. But the inputs of Create CSV table are limited to just the first run in my loop. So my CSV file just has those listed.

Is this a bug? I can't see why this wouldn't be bringing across everything from the Compose outputs. I have also tried creating the table from the variable but I get the same issue.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

Please show more details of your flow.

Was this reply helpful? Yes No
CAlvy 216 on at

Like (0)

Report

See below:
1.Setting variables and preparing selected site names from the app. The outputs from the PowerApp are all site URLs.
2. Within the first apply to each, get the libraries for each site and define the required columns
3. For apply to each 3 within apply to each 2, get the files from each library, select the columns required and append to the files string variable

4. Outside of the loops, Compose 2 takes the files variable and we use that to create the CSV table
5. Finally create the file and open it in the app.
As mentioned previously, outputs of Compose 2 includes all files from within apply to each 3.
Inputs of Create CSV table 2 only includes files from the first run of apply to each 3.

Was this reply helpful? Yes No
CAlvy 216 on at

Like (0)

Report

So I worked out why the CSV table wasn't using all the outputs. There were ][ characters in the outputs of Compose 2. The ] would have been read as closing the array. I have used a Replace expression to replace these with a comma. However, now it's not reading the outputs as an array. I got the error:
The property 'columns' must be specified unless the 'from' property value is an array of objects.

I thought it was because the code begins with "[{ and ends with }]" so I tried to do another Replace just to remove the opening [ and closing ] but now it's reading it as an object and not an array. Any ideas on what else I could try please?

Was this reply helpful? Yes No