I have more than 150 excel files which all have same information table to update their production from different location. my question is can I use Power Automate to import and consolidate all data in a list in SharePoint?

thanks in advance

1 Answer 1


Yes it is possible. There is an action available in power automate for it.

enter image description here

To access Excel with a dynamic path, you can refer this https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-How-to-access-Excel-with-a-dynamic-path/ba-p/462763

You can create an array of locations in power automate and loop through it. I haven't implemented anything similar, so this is my suggestion.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.