I am trying to split the data which I have converted by using HTML to Text Converter in Power automate. However, my data doesn't have any Delimeter, but every data is in new line. Following is the data which I am getting after converting an email into text and I need to put it in their respective column, for instance, full name value should go into Full name column, but there is no delimeter in it.
How would I syntax the command so that spilt functions put the data in proper column in list.
Current split syntax is split(outputs('Html_to_text')?['body'], '%0A')[3]
I have replaced with Enter, \n and few others, but none worked
You have a new website form submission:
1. Full Name
Test 123
2. Email Address
abc@abcd.com
3. Contact Number
01234567890
4. Message
Looking for some assistance
5. Submission Date
20/11/2022
6. Refer URL
https://www.mywebsite.com/contact [https://www.mywebste.com/contact/ ]