web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Populate Sharepoint Li...
Power Automate
Answered

Populate Sharepoint List from E-mail based on tags instead of delimiting

(0) ShareShare
ReportReport
Posted on by 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?

Categories:
I have the same question (0)
  • Verified answer
    v-mingkz-msft Profile Picture
    Microsoft Employee on at

    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:

    vmingkzmsft_2-1686893237422.png

    Following is my Flow:

    vmingkzmsft_0-1686896766252.png

     

    vmingkzmsft_1-1686896846367.png

    The inputs of Compose2 is: split(outputs('Html_to_text_2')?['body'],'|').

    The function in condition3 is: variables('array')[1].

    vmingkzmsft_2-1686896926936.png

     

    vmingkzmsft_3-1686897199077.png

     

    vmingkzmsft_4-1686897291357.png

     

    Following is my SP list:
    vmingkzmsft_5-1686897374281.png

     

     

    Best Regards,

    Kyrie Zhang

     

     

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard