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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse Email Multiple t...
Power Automate
Unanswered

Parse Email Multiple text to sharepoint list row by row

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

I wanted to parse the email text for example:

 

Hi, 

 

This is your Quote#: 13213546 and Order#: 79268. Below are the details for the order confirmation:

 

Product: Black Wardrobe

Quantity: 3

Order Start Date: 6/10/2022

Order End Date: 9/10/2022

Order Term (Months): 1

 

Product: White Wardrobe

Quantity: 10

Order Start Date: 6/10/2022

Order End Date: 7/10/2022

Order Term (Months): 1

 

to sharepoint list where quote no and order no are duplicate in sharepoint, for example:

 

Quote NumberOrder NumberProductQuantityOrder Start DateOrder End DateOrder Term (Months)
1321354679268Black Wardrobe36/10/20229/10/20221
1321354679268White Wardrobe106/10/20227/10/20221

 

I have created the flow but I just get first row not the next set of structured data. Anyone know how to automate this? This is just example with 2 set, there might be 10 or 100 set in one email. Appreciate if the community can help me. Thanks

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at

    hi @sarahairis  you need to use Indexof Funciones de Power Automate - IndexOf - YouTube

  • sarahairis Profile Picture
    on at

    Hi Christian,

     

    Thank you for recommending the function but I still don't how to apply the indexOf function in my flow. The functionality of IndexOf like looking the number of positions for the character. How it supposed to connect with my problem? If you don't mind, could you show me the flow?

  • sarahairis Profile Picture
    on at

    Anyone can help me? I have no idea how to do it besides that I'm a newbie to power automate flow. I created the flow but got the first row that I wanted, not the 2nd, 3rd, 4th, etc (until the iteration stops).

     

    sarahairis_0-1665087570206.png

    Quote No: trim(first(split(last(split(body('Html_to_text'),'Quote#')),'has')))

    Order No: trim(first(split(last(split(body('Html_to_text'),'Order# ')),'was')))

    splitintoLines: split(outputs('Html_to_text')?['body'], outputs('newLine'))

    Filter Array: length(trim(item()))

    Order Details:

    Product - trim(split(body('Filter_array')[6],':')[1])

    Quantity - trim(split(body('Filter_array')[7],':')[1])

    Order Start Date - trim(split(body('Filter_array')[8],':')[1])

    Order End Date - trim(split(body('Filter_array')[9],':')[1])

    Order Term (Months) - trim(split(body('Filter_array')[10],':')[1])

     

    What should I do or improve my flow?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard