I have a query about Sharepoint List in sending emails.

Help needed in creating the below requirements please -

  1. Upload excel file contents having multiple rows/columns Example- Name City Country Ron Sydney Australia Jake New York USA

The above rows/column will then need to be uploaded on Sharepoint as lists.

  1. After uploading the lists onto sharepoint, an email has to be sent to the names given under the column "Name" respectively.

Please help. Thanks in advance.

Regards Chandan

  • I think you will have to alter the Name column to a people field and provide either the users e-mail address or the user ID, otherwise there is no way to send the email Aug 18, 2018 at 8:01

1 Answer 1


Read the excel file as a csv using powershell import-csv. Add the list items using set-pnplistitem (https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/set-pnplistitem?view=sharepoint-PS) and send the email using parts of this: https://blogs.technet.microsoft.com/mikelee/2017/12/23/test-email-from-sharepoint-using-powershell/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.