Flow creating multiple items on a list

(0) Share

Report

Posted on by 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.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
DemoMan 55 on at

Like (0)

Report

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

Was this reply helpful? Yes No
apearson 2 on at

Like (0)

Report
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 1

Part 2

Part 3
Any help would be greatly appreciated!

Thank you,
Alex

Was this reply helpful? Yes No