Hi all,
I have a CSV file in a SharePoint Online library.
I'd like to create a FLOW that goes through each line of the CSV file and, using a bit of logic, create or update items in a list.
By example, if my CSV file is the following:
Last name;First name;Email
SMITH;Allan;a.smith@outlook.com
DOE;John;jdoe@outlook.com
If a have a list with the following:
Last name | First name | Email
DOE | John | john.doe@hotmail.com
When I run the workflow, I'd like to do the following:
- when processing first line of CSV file (SMITH), since it does not exist in the list -> creates a new item in the list for SMITH
- when processing second line of CSV file (DOE), since it already exist but email is different -> update list item to set new email for John DOE
The resulting list would then look like this:
Last name | First name | Email
DOE | John | jdoe@outlook.com
SMITH | Allan | a.smith@outlook.com
Is this possible ? Anyone already done something similar ?
Thanks for the help,
Emmanuel