Power Platform Community Forum Thread Details

I'm working on creating a Power Automate flow to streamline the process of loading data from multiple Excel sheets into a SharePoint list. I have ten different Excel files, each with a standardized structure: they all contain two columns, one for "email ID" and another for "course details".

The data in these Excel files is organized such that each Excel file corresponds to a different course. For instance, the first Excel file contains details about the first course, the second Excel file contains details about the second course, and so on.

My goal is to automate the process so that the data from these Excel files is accurately mapped and loaded into the SharePoint list, ensuring that the email ID and corresponding course details are correctly matched and imported.

Would you be able to provide some guidance or tips on how to efficiently set up this Power Automate flow to handle the data loading from these multiple Excel sheets into the SharePoint list? Any insights or best practices would be greatly appreciated.

Categories:

General topics