Unanswered

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

trice602 15,402 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
jcole5352 58 on at

Like (1)

Report

@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!

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

ALWAYS GLAD TO HELP!

Was this reply helpful? Yes No