Populate an Excel Online document with Select action outputs

[CMN12]

Hello everyone,

I'm currently running a flow that counts the number of item for each category in a SharePoint list. I obtain the following results from a Select action:

 

The results are perfectly accurate, however I don't know how to use those outputs to populate an Excel Online document. I would want to obtain something that looks as simple as this:

Marque	Quantité
Kangoo II	21
Kangoo ZE	10

Does anyone know if it's possible?

Thanks in advance !

CMN12

[grantjenkins]

Do you have an existing Excel file stored in SharePoint or your OneDrive that you wanted to populate, or did you need to create one as part of the flow?

Also, would a CSV file be ok instead of an Excel file? Reason I ask is that creating a CSV is very easy, but Excel file takes a bit more work.

[CMN12]

Hello @grantjenkins

I already have an Excel file stored in a SharePoint library that I need to populate, not create a new one each time I run the flow.

[grantjenkins · Accepted solution]

In that case you just need to make sure you have a Table in the Excel file so you can add rows to it.

In my example I have an Excel file called Marque and have a table called MarqueTable with two columns: Marque and Quantité.

I've just used a manual flow and added your JSON data into a Compose action. You already have this data in your Compose action.

I then use an Apply to each to iterate over each of the objects in the array from the Compose output and add them to a new row in the Table in my Excel file.

For each item I have the following:

item()?['Marque']
item()?['Quantité']

The output in this instance would be:

The full flow for this example is below.

[CMN12]

It's working perfectly, thank you very much!