adding rows to excel

[Sharuk]

Hi All,

I'm having an item in my list as shown below

and I want to insert these details into excel file like this

when i use add row action it is showing only details & value like this

is there a way to pass column name into details and relevant field to value to get my desired output like this

[Nived_Nambiar · Accepted solution]

Hi @Sharuk 

You can try this 

I am assuming that you had only 3 columns 

Here i take three columns namely Title, ID, Shift as shown

'I had added data like as below

Now the flow will get triggers like this 

1. Set the trigger when the item is created in sharepoint list

2. Intialize a variable list_data like as below

3. Set variable with values that is the name of columns  which is in sharepoint list like as below

even you can set the values in Intialize variable too .

4. Body of added sharepoint data added in list is also an output from the trigger, use that in Parse Json action to parse the data ie body as shown below

add the schema too

5. Use Apply to ForEach action to loop through each values in list data 

Iniside the loop do the following

use add to row in Excel Online connector

and add the following property values

here in my excel i had item, value column 

in item i will add the Current Item 

in value i will add the following expression : body('Parse_JSON')?[items('Apply_to_each')]  

then after running this process u will get result like this 

Mark it as solution if it helps you

Regards,

Nived N