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)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

Was this reply helpful? Yes No
apearson 2 on at

Like (0)

Report
Copy link

Link copied!
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