Split text into SharePoint List with delimiters

[paradoxian20]

I am taking responses through a Qualtrics form and would like to export response items into a SharePoint list. Each time a response is received, an automated email is sent that triggers a flow. Here is the template of the email:

First Last~email@address.com~1234567890~Month YYYY~Interest Area, Interest Area

Everything in that list is a required field on the form except for phone number, and Interest Area could have 1-4 items selected.

I want split this data into their respective SharePoint List items, which are as follow:

Name

Email

Phone number

Desired start

Areas of Interest (checkboxes)

Here's my incomplete flow as of right now:

As you can see in the screenshot, I've got the trigger, HTML to Text, and Create Item steps, but I need the steps between HTML to Body and Create Item to split the data. I've found help articles using 'Apply to Each' and using defined variables, but I've never been able to apply them to my specific case. Additionally, I would like to split the 'Areas of Interest' from the comma-separated values in the email into checkboxes in the SharePoint list if possible, though it is not absolutely necessary and could leave them separated by commas if need be.

Any help would be greatly appreciated.

[efialttes · Accepted solution]

Hi!

Does 'HTML to text' provides this output? I mean, no more stuff in your email body?

First Last~email@address.com~1234567890~Month YYYY~Interest Area, Interest Area

If so you can do the following:

split(outputs('Compose_myEmailBodyInPlainText'),'~')

Now you can use the following expression to identify Name:

outputs('Compose_myInputFields')[0]

...and, you can use the following expression to identify Email:

outputs('Compose_myInputFields')[1]

...and so on

Hope this helps

[paradoxian20]

Correct! Sorry for the confusion.

[efialttes]

GReat news! I have updated my first post with a potential solution

Hope this helps

[paradoxian20]

Awesome, that works for splitting each List item, thanks!

[efialttes]

Did my first answer solve the initial issue?

CONGRATS!

THen I have good and bad news. Bad News? In my case I've just rejoined to this community after a long time, so my knowledge on certain topics (SP being one of them) is a bit rotten. Good news? Superusers are for sure willing to help!

So my humble suggestion is:

1.-Mark this topic as "Solved" by clicking "Accept as a solution". THis way others facing a similar problem can find a solution faster. Please also note you can even select several responses as solution, even from different community members!

2.- Open a new thread for your next question, following the policy: 'One Question, one post'. This way you have more chances to attrack attention for superusers -> they are seeking for unanswered topics.

3.- (OPTIONAL) Click on 'Thumbs up' in any answer you found valuable... or even in all of them 😉

Thanx for your help making this community great!

[paradoxian20]

Will do, thank you for the quick assistance!

[GabLag]

Hi, this guide is very useful thank you so match!! how can I split the text if in input the words are divided by wrap?

for example:

input - text1\ntetext2\ntetext3\n etc..

output -

text1

text2

text3

etc..

Thank you