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!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

trice602 16,679 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

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.
jcole5352 58 on at

Like
a
(1)

Report
Copy link

Link copied!

@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!
trice602 16,679 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

ALWAYS GLAD TO HELP!