Flow creating multiple items on a list

[DemoMan]

Good Afternoon All, 

Hope I could find some help here. 

I have a simple flow that triggers when a email is received and logs the information for that email to a list. When I receive an email with more than one attachment the flow updates the list with each attachment name as a separate item, is there a way to have the flow put all the attachment names on a single multi line field instead or creating an item for each? 

Thank you for the help in advance. This is a great community. 

[ScottShearer]

Are you asking if you can have 1 list item that contains all attachments for a given email?

If so, here is a screen shot of a Flow that does just that:

If this isn't what you need, please provide some additional detail.

Scott

[v-xida-msft · Accepted solution]

Hi @DemoMan,

Could you please share a screenshot of your flow's configuration?

Could you please show more details about your SharePoint list?

Further, do you want to put all attachment names into a Multiple lines of text column of your SharePoint list?

I have created a SharePoint list on my side and the data structure of it as below:

Note: The Subject and Body column are both Single line of text type column, the Received Time column is a Date and Time type column, the From and To column are both Person or Group type column, the AttachmentNames column is a Multiple lines of text type column.

I have made a test on my side and please take a try with the following workaround:

• Add a "When a new email arrives" trigger, Has Attachment field and Include Attachments field are both set to Yes.
• Add a Variables->"Initialize variable" action, Name set to AttachmentNames, Type set to String and Value set to empty.
• Add a "Html to text" action, Content field set to Body dynamic content of the trigger.
• Add a "Apply to each" action, input parameter set to output of the Attachments dynamic content of the trigger.
• Within "Apply to each" action, add a "Compose" action, Inputs field set to follwoing formula:

concat(item()?['Name'],'</br>',variables('AttachmentNames'))

Add a "Set variable" action, Name choose AttachmentNames, Value set to output of the "Compose" action.

• Under "Apply to each" action, add a "Create item" action, the AttachmentNames field set to AttachmentNames variable.

Image reference:

The flow works successfully as below:

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

Best regards,

Kris

[DemoMan]

Thank You Very much! @v-xida-msft This worked great!

[apearson]

Hi Kris,

I am trying to combine a couple of your examples to take a list of sharepoint items and combine them so I can put them into a word template using a thrid party flow. Here are the other examples that I am working off of:

• https://powerusers.microsoft.com/t5/Building-Flows/Convert-array-to-string/td-p/79125
• https://powerusers.microsoft.com/t5/Building-Flows/Clear-array-variable-in-a-flow/td-p/81772).

I seem to be getting stuck at your concat function. When I try to use this and it flows back into my test list, it apears like this: 

Here is a copy of the code I am using: 

concat(item()?['Title'],'</br>',variables('Augmented String'))

Here are three pictures of my flow:

Part 1Part 2Part 3

 Any help would be greatly appreciated!

Thank you,
Alex