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.
Solved! Go to 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:
concat(item()?['Name'],'</br>',variables('AttachmentNames'))
Add a "Set variable" action, Name choose AttachmentNames, Value set to output of the "Compose" action.
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
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
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:
concat(item()?['Name'],'</br>',variables('AttachmentNames'))
Add a "Set variable" action, Name choose AttachmentNames, Value set to output of the "Compose" action.
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
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:
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:
Any help would be greatly appreciated!
Thank you,
Alex
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
12 | |
7 | |
4 | |
4 | |
3 |
User | Count |
---|---|
11 | |
8 | |
5 | |
5 | |
4 |