*Repost* Parsing Dynamic Data in an Email Based on a Delimiter and Create SharePoint List Items

My apologies for reposting. The other thread was marked as "Answered" but the response I received did not address the question. I tried to remove the checkbox next to "did this answer your question" but the page has been spinning for 37 minutes...still.

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). But again - those numbers WILL vary by project (could be 8 on project A, 4 on project B, etc.)

The format for Number, Name, Senior Lead, and Lead is static -- and I know how to parse/split these fields, map them to a SharePoint list item, etc. This isn't the issue.

I'm stuck on how to account for the varying number of 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. Thanks in advance for any help.

Categories:

Process Advisor

Quick Links