Hi All,
Please let me know I want to insert data in a list by reading this excel which have email IDS like below-
amir.khan@org.com
Sushmita.rao@org.com...etc
my code/script will pick the email IDs , on basis of email id i can get firstname,middle name, last name .
While inserting/creating entries in list I need to set below list column values-
Title(col1) | Email(Yes/No type col)| AffectedLine (Choice col) |Created By (Default col) | Modified By(def col)
Subscription | Yes | All | Amir,Khan | Amir, Khan
Subscription | Yes | All | Sushmita,Rao | Sushmita,Rao
CSOM/Console application /powershell script to insert data in a sharepoint list by reading email IDs from an excel but created by and modified should be email ID