Answered

Use one field, parse text from it two ways and then populate to two fields

(1) Share

Report

Posted on by jcole5352

Hello

I have a flow that is taking Microsoft Forms responses and creating a SharePoint List item. In the forms responses I have ONE field that contains two pieces of information that I want parsed. It's formatted like this:

Doe, Jane - janedoe@xxxxxxxx.edu

Form field is called Course Director 1

This particular one field contains two pieces of information in one string. Is it possible to add dynamic content or use an expression to parse out the text so that I can put the name in one field and the email in another for when it goes over to the SharePoint list. See screen shot.

THANKS IN ADVANCE!

All responses (3)

Answers (1)

trice602 13,813 Super User 2025 Season 1 on at

Like (0)

Report

Re: Use one field, parse text from it two ways and then populate to two fields

ALWAYS GLAD TO HELP!
jcole5352 58 on at

Like (1)

Report

Re: Use one field, parse text from it two ways and then populate to two fields

@trice602
OMG thank you for the amazingly fast response!! AND it worked!

However, Since I have to do this for multiple fields, I'm not using the Compose, I'm just calling to the output of the field from my 'get response details' directly in the trim and split string.
Like this:

Because I didn't know if I could have multiple Compose steps. It seems to work so hopefully it doesn't cause me problems down the road.

Anyway, I think I'm rocking and rolling now! Thanks so much!
Verified answer

trice602 13,813 Super User 2025 Season 1 on at

Like (1)

Report

Re: Use one field, parse text from it two ways and then populate to two fields

Hi @jcole5352 ,

Here are the expressions and results:

trim(split(variables('test1'), '-')[0])

split(variables('test1'), ' ')[sub(length(split(variables('test1'), ' ')), 1)]

Next you would use these dynamic values in your Create Item.