web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Concatenate multiple f...
Power Automate
Unanswered

Concatenate multiple form fields into formatted list in SharePoint item

(0) ShareShare
ReportReport
Posted on by 11

Hello, I have multiple fields on a form that I would like to format to appear as a comma delineated list in my sharepoint item, or ideally as a block with each field entry on its own line. 

 

Here is my current flow with Create item pulling in MS form entries. For Course Name, I have 8 different fields from my form (user can potentially enter up to 8 courses at a time for reimbursement, and unfortunately they are all named the same thing in the form): https://imgur.com/Fx5oE61 

 

When the flow runs, this is how the field entries in Sharepoint are created. I'd like them separated by either a comma or a line break: https://imgur.com/w2ucU7j 

 

I understand how concatenate works in theory, but when I tried implementing this as an expression on my create item field, it did not like using the form responses in the expression - do I need to implement some kind of compose operation and then update item? I'd prefer to do this with all 8 course name fields at once, rather than 8 different compose or concatenate functions.

 

Thank you very much - this one has really stumped me and I'm still learning Power Automate.

Categories:
I have the same question (0)
  • Verified answer
    PrasadAthalye Profile Picture
    on at

    Which column from the flow action you are referring to? If it is Course names, you can simply enter a comma in each of those form fields to generate comma-separated values.

  • Verified answer
    ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at

    hi @l9hunter if you want to add comas you can type it like this

    asd.PNG

  • l9hunter Profile Picture
    11 on at

    @ChristianAbata @PrasadAthalye thanks to you both. I guess in the complexity I overlooked you can just separate with commas. 😂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard