Power Automate - Community Question - Metric Totals

[@norhidayah889]

Hi, great video. Do you mind to share the steps if we want to insert the value into excel instead of send an email?

[@abm4975]

So what you want to insert? Just the totals? Pls give me a context of your data structure.
Thanks

[@norhidayah889]

@@abm4975 i have 117 sharepoint list with the same structure and column name. All the data in all list need to be merged and exported into a single excel. For column name example: Title (text), Computer Name (text), Status (dropdown value).
List A:
Title ComputerName Status
A Lenovo Returned
List B:
Title ComputerName Status
B DELL Broken
Data exported into a single excel:
Title ComputerName Status
A Lenovo Returned
B DELL Broken

[@norhidayah5306]

​@@abm4975 i have 117 SharePoint list where the data in all lists need to be merged and exported into a single excel file. Sample as below:
List A:
Title ComputerName Status
A Lenovo Returned
List B:
Title ComputerName Status
B DELL Broken
Result in excel:
Title ComputerName Status
A Lenovo Returned
B DELL Broken