Power Platform Community Forum Thread Details

concatenating Data from 40 Fields in Power Automate

Hi Community :

I'm a rookie , I'm learning Power Automate and I've run into a problem. I have a form, and as it's designed, there's a field that repeats 41 times (for example, name1... name 41), but only one value can be in the field. So, I wanted to take that information to an Excel and I want to concatenate all the values. How would that be done? Can I use a regular expression?

For each item in Form_responses
- Start a loop
- Action: Concatenate strings
- String 1: Response_of_field_1
- String 2: Response_of_field_2
- ...
- String 40: Response_of_field_40

Thanks

@ravamo0053 The Get Response details action returns an Object. When you use a When a New Response is Submitted trigger, it only returns a single response.

You won't be able to loop through your responses. You can use a Compose action and an expression. Use the concat() function. Insert your dynamic content for each field into the function separating each with a comma.

Test it out on the first 3-5 fields before you try to do all 40.

If you only want to collect the result if the value is not blank, you can do that as well. I cover how to build that expression in the tutorial linked below.

How to Get a Microsoft Form RSVP Response into a SharePoint List

I cover the following in this video tutorial:

✅ How to get a Microsoft Form Response into SharePoint

✅ How to get a Microsoft Form ID

✅ How to get a Microsoft Form response

✅ How to Build a Microsoft Form with Conditional Fields

✅ How to used Branching in Microsoft Forms

✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

✅ How to parse a Microsoft Form multiple choice response as string of text

✅ How to convert a text response to a number

✅ How to use the Switch action

✅ How to create a custom email confirmation for a Microsoft Form submission

✅ How to Create a Custom View in a SharePoint list

✅ How to use the Compose Action

✅ How to write Power Automate Expressions

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Quick Links