Parsing Data in an Email Based on a Delimiter and Create a SharePoint List Item

(1) Share

Report

Posted on by Chris110

Hi all

I have an interesting use case for which I haven't found a clear answer yet.

I have an automated email that gets sent to an unmonitored mailbox when an evaluation needs to be filled out for a completed project. The format includes

Project Number | ###

Project Name | xyz

Project Senior Lead | Name | Email

Project Lead | Name | Email

The problem I'm trying to solve is related to Project Participants because it will ALWAYS vary by project. The goal is to create a SharePoint list item (evaluation) for each Participant and one evaluation for the Lead. In the case where we have 8 PTs, we would have 9 items created (1 for each PT and 1 for the Lead).

The format for Number, Name, Senior Lead, and Lead is static -- and I know how to parse/split these fields. I'm stuck on how to account for the varying Participants. My fields in the SharePoint list include SrLeadName, SrLeadEmail, LeadName, LeadEmail, PTName, PTEmail. I was trying to experiment with some kind of count variable but got stuck. If I need separate lines for the names/emails of the PTs, I can probably have the team do that and make it align.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Please refer this blog on how to extract values from email.

Extracting key values from an Email - Powering your Apps (sudeepghatak.com)

Once you have the Participant information, you can use split() to create an array of participant names.

You could then loop through this list and create items in SharePoint.

Let me know if you run into issues.

Was this reply helpful? Yes No
Chris110 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Sudeep - I'm familiar with how to parse the data when it's static (e.g. one contract number in your example) but I'm stuck on what to do when there's a varying number of delimiters separating data that needs to be split. And how to take those and create SharePoint list items.

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Chris,

To handle varying number of delimiters, save the output of split in an array and loop through the array.

Do you want me to build a sample for you? Let me know.

Was this reply helpful? Yes No
Chris110 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sudeep

An example of that would be incredibly helpful! Thank you very much.

I would assume that, within the loop, we would also have the create item in SharePoint? And outside the loop, we can split/parse the static data?

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Please see the attached sample

Attachment

Was this reply helpful? Yes No