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
Solved! Go to 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
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
User | Count |
---|---|
27 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
22 |