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.
