Parse Email Multiple text to sharepoint list row by row

(0) Share

Report

Posted on by sarahairis

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 Number	Order Number	Product	Quantity	Order Start Date	Order End Date	Order Term (Months)
13213546	79268	Black Wardrobe	3	6/10/2022	9/10/2022	1
13213546	79268	White Wardrobe	10	6/10/2022	7/10/2022	1

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:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sarahairis on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
sarahairis on at

Like (0)

Report
Copy link

Link copied!

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).

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?

Was this reply helpful? Yes No