Power Platform Community Forum Thread Details

I have created an office 365 SharePoint list containing eight columns. Two of the columns are auto populated from an MS Form. This works fine.

I now want to populate some of the other columns pulling the data from an excel file that is stored within the SharePoint site. The Excel file has more columns than those required for this list.

The common field is an e-mail address, the excel file has circa two thousand rows and i only want to pull back the data for the number of records that are in the SharePoint list around twenty where data has not been updated previously i.e. if column "Employee Name" is blank bring back the data.

Any help would be greatly appreciated

Categories:

General topics

Hi @Anonymous,

I assume that you have two flows. Flow1 is used to submit responses from Forms to SharePoint list. Flow2 is used to get columns from the Excel tables then update the list.

From your description, there is a common field between the list and the Excel table, and there are two thousand rows in the Excel table.

I have made the following test for your reference. In my scenario, the common field is the name of the user.

It is triggered by When an item is created.

As you mentioned that the Excel file is stored within the SharePoint site, we are going to use the connector Excel Online. Add the action List rows present in a table. And enter the following code into the Filter Query field to get the specific row:

Name eq ‘Dynamic content Title’

Add the action Update item, then fill in each column with corresponding fields from the Excel table. At here, once you select dynamic contents from the previous, an Apply to each will be added automatically.