
Announcements
Hi there,
I am having trouble loading in historical data into my SharePoint list from an excel table. All the other columns are being filled properly except for the lookup column I have. The run is successful but only 1 value (the first value) from the excel table for the lookup column gets loaded in and not the rest.
SharePoint List is called " Group/Workshop Attendance Tracker "
Lookup Column's List is called " Attendee Registry "
Excel File is called "Attendee List for Import" --> Table in the file is called " LOAD - Attendance Info"
The Lookup column is called "Unique ID" in the Attendee Registry and in the Group/Workshop Attendance Tracker is called "Attendee ID".
I have the flow outline attached as well. Please let me know how to fix this.
No other field was used besides the ones I have displayed.
See screenshots below: