Power Automate - Community Question - Metric Totals

This video is based on a Power Automate Community question
powerusers.mic...
Expression xpath
xpath(xml(outputs('JSON_For_Each_Month')),concat('sum(/root/',outputs('Each_Month'),')'))

[@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