I have a SharePoint list which I accidentally changed the column type of the Site column which emptied all 3000 entries in that column. I have an excel sheet with the same information from the list. I would like a automate flow to pull the request ID field from the SharePoint list and compare against the excel sheet and then return the corresponding Site value from that excel sheet into SharePoint. Any way this can be accomplished?
Does your Excel spreadsheet contain the ID that corresponds to the ID of the item in SharePoint. If so, just use the get rows action following by an apply to each. In the apply to each, add an update item action on your SharePoint list and use the ID from the Excel file to specify the ID of the item in SharePoint. You will probably need to use an int expression on the value.
You will also need to enable paging on some of the actions since you have 3,000 rows of data. By default, the Excel action I believe will only work with the first 256 rows and apply to each will work with 100.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
14
Share
Report
All responses (
Answers (
