You’re offline. This is a read only version of the page.
Announcements
161
Hello,
I watched a good video explaining how to use HTML->Text and Split functionality with a delimiter and a pipe ( | ), however the contents of my form can change based on parent selections.
Example:
User selects value from Dropdown 1 in form, this enables 3 more required fields. So my e-mail body ends up with 4 unique values, all delimited with a pipe, and I can split and create Sharepoint Item without issue, mapping to the proper SP columns.
But, if the user selects a different value from Dropdown 1, this will enable 6 new required fields, all different than the 3 in the first example. So what ends up happening is my split function assigns the wrong value to the SP column because it is only written for one permutation of form data.
So, how can I stop relying on splitting of arrays based on delimiters and instead, have Flows actually look for a specific string of text and only map it to the specific SP column?
Hi @glowerpower,
Do you want to put the data in the email's body which is from a Form into a SP list?
Please offer me more information:
1. What types of your email's body?
2. Does your email body is a text contains the questions and answers separated by "|" ?
3. If you use add branching to control the required fields in the Form?
4. If your Form has three questions if you select 'option1' in the Dropdown, and six questions with selecting 'option2'?
I did some test according to your requirements.
I assume the email body as:
Following is my Flow:
The inputs of Compose2 is: split(outputs('Html_to_text_2')?['body'],'|').
The function in condition3 is: variables('array')[1].
Best Regards,
Kyrie Zhang
Share
Report
All responses (
Answers (
