I have created a flow that starts when a new email (with a specific title arrives). The email contains a table of 3 columns and three rows.
Title | | | 1 Specific Title | | |
Site Owner | | | 3 email addresses | | |
Justification | | | 5 |
|
When the email arrives, I use the html to text to convert it. Then i use a compose to split it into sections.
Title
Site Owners
Justification
Then I use a Compose to split out the section with the three email addresses
Then i initialize a variable called site owners of type array
I then create an Append to Array variable and add the outputs from my compose to it
An Apply to each is then added with a SharePoint Create Item
The Current Item is then added to the array
The flow runs without error but only adds one of the three names to the SharePoint list column
I have tried separating the email address with comma, semicolon. and pipe. nothing works. I know I am not doing something write in this step but I don't know what. Any help would be appreciated.


Report
All responses (
Answers (