Separating Attachment File Names

(1) Share

Report

Posted on by billf24

169

In my flow, I update a SharePoint List column with the names of the attachments from a form. The column is Text, Multi-Line.

What is the best way to separate them, preferably with a CR so the next attachment name is on the next line.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Use Concatenate(filename, uriComponentToString('%0D'), uriComponentToString('%0A')) to create a string that ends in a carriage return and linefeed. Then Append that to a String Variable. Then you can use the string variable as input for the multiline field.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
you can also try below :

join(variables('AttachmentNames'), decodeUriComponent('%0D%0A'))

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @billf24,

Use a join expression with a newline character to combine the names.

If you have an array of attachment names, use this expression in a Compose or Set Variable action:

join(body('Your_Trigger_or_Action')?['attachments'], decodeUriComponent('%0A'))

The decodeUriComponent('%0A') produces a line feed character which SharePoint multi-line text fields render as a new line.

If you are building the list inside an Apply to each loop, initialize a string variable before the loop and append to it each iteration:

Append to string variable:
variables('FileNames') + item()?['name'] + decodeUriComponent('%0A')

Then use the variable in your SharePoint Update item action.

If you need a true carriage return + line feed (CRLF) instead of just LF, use decodeUriComponent('%0D%0A') instead.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @billf24,

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Also, if the issue is resolved, it would be great if you could mark the answer as solved so others with the same question can find it easily.

Thanks and have a great day!

Was this reply helpful? Yes No