0

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

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

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

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