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
Project Participants | Name1 | Email1 | Name2 | Email2 | etc... ***This varies from project to project****
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.
95
Share
Report
All responses (
Answers (
