Concatenate SharePoint List Attachment Titles

[SylvieLet17]

Hi all, 

I have a SharePoint list with attachments.

I need to get the names of all attachments and save this data into a "Multiple Lines of text" column in the list. 

I'm close, but I need help with the formula. 

I'm using a "Get attachments" action, then a "set variable" action from the outputs like so:

concat(body('Get_attachments')) 

This gives me something like this:

[{"Id":"%252fLists%252fContract%2bRegister%252fAttachments%252f98%252f098%2bSupplierX%2bTechnology.pdf","AbsoluteUri":"https://Mydomain.com/Lists/Contract Register/Attachments/98/098 Mexon Technology.pdf","DisplayName":"098 Supplier Technology.pdf","@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListItemAttachment"}]

I tried:

concat(body('Get_attachments')?['DisplayName']) but that was invalid because "...property 'DisplayName' cannot be selected. Array elements can only be selected using an integer index."

So basically all I need is the DisplayName of each of the items in the output of Get Attachments. 

Any suggestions?

Thanks

[Alex_Bondin]

Hi @SylvieLet17 

"Get Attachments" action returns array so I would suggest approach below:

• Create variable "AttachmentNames" as array, where you store all attachment names
• Add "Append to array variable" action and select "DisplayName" property from "Get Attachments" action. It adds "Apply to each" action automatically.
• You can use join(variables('AttachmentNames'),'; ') to convert array into string

• You can use join(variables('AttachmentNames'),'; ') to convert array into string

[v-alzhan-msft · Accepted solution]

Hi @SylvieLet17 ,

Please refer to screenshot below to create the flow to achieve your needs:

Please let me know if your problem could be solved.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.