AnsweredAssumed Answered

Update List Items from Excel

Question asked by andrew_valentine on Apr 3, 2016
Latest reply on May 24, 2017 by tposzytek

I must stress this question is for Nintex and SharePoint online. The resources I have found so far focus on On-Prem solutions and I have so far been unable to convert those processes into a Nintex 365 format.

 

My query is, is it possible/how would I go about updating List Items in "MainList" from a document (Excel) in a document library "PlannerLibrary"?

 

Currently I update a list called "Planner" with information various contractors send through in Excel. There is a workflow on that list when items are added or modified that will update the Jobs List (main list) with the planner information.

 

Ideally I would like to upload the Excel file to a document library and have a workflow read this file for "Job Numbers" and update items in the main list where "Excel:Job Numbers = MainList:Job Numbers" - thus eliminating the process of copy/paste from excel to Access to update the planner list (this list could grow greatly and waiting for the sync from Access to SharePoint makes this process 'bad for business')

 

I must stress this question is for Nintex and SharePoint online. The resources I have found so far focus on On-Prem solutions and I have so far been unable to convert those processes into a Nintex 365 format.

Outcomes