Share
Report
304I'm having trouble with this use case and not sure how to handle one of the array columns.
SharePoint list contains request items. I want to send an email monthly that lists the open items for each Submitter. Everything works except I don't know how to handle one of the complex columns in the output email.
SP list design
| Column type | Contains |
| Text | Request title |
| Person (single) | Submitter person |
| Person (multiple) | Assigned people |
| Choice | Status value, single choice |
Current flow design, it works except the final output does not contain a column identifying who the Assigned people are
- Scheduled trigger
- Get items
- I use a loop to add all the Submitter Emails to an array variable and the Submitter DisplayNames to an array variable
I then use a Compose action with Union function to remove duplicate Submitter Emails, the output of this compose action is to create another array variable with Submitter Emails (no duplicates)
I then loop through each of the Submitter Emails in the array to filter and select the items for each Submitter. The filtered and selected items are then put in an HTML table and email sent.
This solution works, however I would like to add a column to the HTML table the identifies the Assigned people. The Assigned people is a Person array within the Get items array. I thought of creating a string variable, and appending the DisplayName of each Person assigned. I don't know how or where to create this loop since I'm already using a filter and select function in this loop of each Submitter.
Any help would be greatly appreciated. Thanks.
All responses (
Answers (
