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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / On form response split...
Power Automate
Unanswered

On form response split string (unknown length) into column and add submission date to next column.

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

Is this possible?!

 

I am receiving form responses with strings of data in this format GYB23569RYF26985KIY89652, the actual length of the strings will vary. On form response, I need to split this string into GYB23569 RYF26985 KIY89652 so that each value is in a separate row in a column, with the corresponding form submission time in the adjacent column.

i.e. 

22/06/2024 15:22GYB23569
22/06/2024 15:22RYF26985
22/06/2024 15:22KIY89652

 

Is this possible? I cannot find a way to divide a string without a known delimiter.

Categories:
  • Ellis Karim Profile Picture
    12,377 Super User 2026 Season 2 on at

    Hi @Ollie23 ,

     

    If you don't have a known delimiter, can you split the string into blocks of 8 characters? 

     

    If so, you could try the following:

    2024-06-22_13-56-14.PNG

    Here is the sample runtime output:

    2024-06-22_13-57-10.PNG

     

    The chunk() function splits the string into blocks (or chunks) of 8 characters:

     

    [
     "GYB23569",
     "RYF26985",
     "KIY89652"
    ]

     

    You can then use the following expressions to reference the items in the array:

     

    outputs('Compose')?[0]
    outputs('Compose')?[1]
    outputs('Compose')?[2]

     

    2024-06-22_13-57-10.PNG

    Ellis
    ____________________________________
    If I have answered your question, please mark the post as ☑️ Solved.
    If you like my response, please give it a Thumbs Up.
    My Blog Site

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 288 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard