Forum Discussion
Power Automate Flow help needed please
Anonymous I don't know about your specifc example but in general, it's easier to connect a sharepoint excel file to Power Automate when the excel data is marked as a table.
To see how this is done, you can look here: https://support.microsoft.com/en-us/office/create-a-table-in-excel-bf0ce08b-d012-42ec-8ecf-a2259c9faf3f
Hi sethneds
Thank yo for your response. that part is all easy. Yes excel tables are being uploaded to sharepoint list, and then the totals are being added using calculated function in SharePoint List.
Once all above is done, we want to then automatically pick only the calculated column showing grand total from each list, to a new slimmed down SharePoint list that will only have 2 columns (as per example showing List C). To this new List (List C) to then be able to view the values as a general number where we can then carry out further analysis