Skip to main content
Nintex Community Menu Bar

Nintex Workflow - Parse CSV file in a Document Library and Insert or Update a List Data

  • February 3, 2020
  • 1 reply
  • 91 views
Forum|alt.badge.img+1

Hi Team,

We are getting daily Feed files in CSV format and they get loaded into SharePoitn 2013 Document Library.

We are planning to create a Workflow on Doc Libraty so that the data can be inserted and udpated (if the same data already available in the list).

Ex: Employee Id, First Name, Middle Name, Last Name, Status (Active/InActive) - Data comes in CSV.

 

How can we Update the Data in the list if the same Employee record (by Employee Id) got changed today because of the CSV feed ?

 

https://www.youtube.com/watch?v=GBU4p0gRdOU - Video shows how can we insert new records all the time but it won't talk about how to update the exisiting record.

    1 reply

    Forum|alt.badge.img+8
    • Tarf
    • Novice
    • February 5, 2020

    Instead of creating an item (Video: 5:57), check if an entry in your people list with the employee id already exists. (For example using query list - Employee Id matches - count returned elements)
    If the entry exists, update it, if not, create it.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement