cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Split text into SharePoint List with delimiters

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:

 

Clipboard02.png

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Split text into SharePoint List with delimiters

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'),'~')

Flow_scraping.png

 

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

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

6 REPLIES 6
Highlighted
Dual Super User III
Dual Super User III

Re: Split text into SharePoint List with delimiters

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'),'~')

Flow_scraping.png

 

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

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Regular Visitor

Re: Split text into SharePoint List with delimiters

Correct! Sorry for the confusion.

Highlighted
Dual Super User III
Dual Super User III

Re: Split text into SharePoint List with delimiters

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

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Regular Visitor

Re: Split text into SharePoint List with delimiters

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

Highlighted
Dual Super User III
Dual Super User III

Re: Split text into SharePoint List with delimiters

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!

 

Flow_AcceptSolution.png

 

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 😉

 
Flow_thumbsUp.png

Thanx for your help making this community great!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Regular Visitor

Re: Split text into SharePoint List with delimiters

Will do, thank you for the quick assistance!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (7,018)