Hi
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