Been trying to figure pretty much exactly this out and could never find an explanation that allowed me to understand what these commands were doing. This actually gave me a solid understanding of what was going on.

Absolutely brilliant! You taught not just how to get the job done but also the other principles involved that MOST tutorials leave as a mystery on how it they came to be. The pacing was great, you kept it organic and it your speaking voice is pleasant and easy to follow! One of the best in IMHO. Cheers!

Honestly, I've been doing Power Automate since Tuesday afternoon - this has helped massively understand the process of some of these simple flows using regex - thanks so much.

Immensely helpful video and explained so well. You just solved so many issues I had in a single video. You've got yourself a new lifetime subscriber.

Finally I have found something that can help with an email / automate problem I have. Thank you!!!!

Very useful video. No water - just practice. I have just started studying PA and I am glad that I found your channel. Wish you more happy subscribers!!!

I really like the Parse JSON approach, you start to explain at 11:36

I was tyring to get this with god know how many function...non worked...this has absolutely solved, thanks a ton !!

Great stuff Speedy Gonzalez, thank God for pause/rewind but I like your approach.

Thank you so much. It's amazing. I learn a lot from your videos.

After searching many video, finally I can manage created list from email body text.. Tqvm Paulie.. Appreciated..

You taught me much more than any crappy video out there, gem of a tutorial ❤️

You helped me to solve a problem that I was facing for weeks. Thank you so much, Paulie.

i tried my flow and it works with your brilliant example and discription!

Hi Paulie, Thank a lot for sharing this video.

Clean and concise. Nicely done.

Simply amazing. Exactly what i needed. thank you alot.

Wonderful and extremely useful. Thanks a lot!!!

Hi Paulie, thank you so much for this tutorial. This 'newLine' trick is very impressive to a beginner like me.

Great stuff! Thank you for sharing...

Thanks man. Learned a lot of from this and helped me complete a task.

Wow I’m a newbie to this :) most of what you did went right over my head but my word… the concept and your pragmatic approach is amazing looking forward to much more of your vids

Just what I what looking for! Thanks!

Thanks for the tutorial, this will be great for what I want to do.

Thanks a lot for sharing very helpful tips and tricks

Amazing video, very grateful

Amazing!🎉 Thank you for sharing your knowledge!👏

Thanks a ton, great great work. Genius.

Great explanations, it helped me a lot, many thanks and Hayppy New Year !

Brilliant tutorial! Thank you

Thank you so much, this was so helpful!!!

This video helped me a lot, thanks!

Thx a lot nice way to parse html email :)

Hey Paulie, (if this is the right name i can call you) Thank you for this, this is the clearest instruction ever made and helped me alot. For a beginner like me its very informative and easy to catch on. Kudos!

hi Paulie, how to get optional field value(With or without value) using array. its throwing error " cannot be evaluated because array index '1' is outside bounds (0 0) of array". can u please suggest how to overcome this error.

this tutorial is great 💥💥💥

Exactly what i wanted

Great thanks to you sir

@Paulie M - After the filter array function, the array item I would like to isolate does not need splitting. What action should I use instead of split?

This is great, thank you for sharing. I wanted to check if you can guide when the header in the html table in the email body is listed in a column on the left side. What syntax can I used to extract the data that is associated with the header. I have used split and keep getting blanks within “”. Thank you again.

Thanks 🙏🙏🙏

hi, thanks for the tutorial, please explain why compose empty, and deleted the line "0" at the notepad

Hey Paulie, questions for ya. If one of the elements I'm trying to move from the array spans multiple lines (a message from a form submission) how would I put all of those into a single output?

Great video and you explain perfectly. I do have a question regarding multiple lines of an email. I have the same information in an email, but I have the same information many times in multiple lines. How do I have the same flow, but parsing using multiple lines???? Many Thanks

Thank you! Create explanation.

can we use this method to record and move the old mails to excel?

Your instructions are fantastic! I have a follow-up question: If I have emails that contain variable rows of information that I want exported to a SharePoint list, such as a sales order confirmation email that contains up to 100 lines of purchased items, can I modify this flow so that it exports all the lines of data?

thanks.

i have a excel table in mail, when to do split in to lines the values in 3 coulumn are printed as Concatanated, there is no space or new line between them. Any idea how to split them? those are variable

Good video, it helps me to good start. 😊👍 Can you tell me Attachments of the mail how you are parsing through flow

Hi Paulie, thanks for sharing this. i have little confusion on why do we need to create "New Lines" command. what is the purpose of this command? if to remove the "empty" line, you will be creating "length" funtion >0 which will not return the "empty" line. thank you in advance!

Would love to see how the Excel Sheet would look like ^^

Great work! One question if i may. Is there a way to skip filter because some times fields are left blank and creates problem with numbering. I tried to skip filtering but then the flow does not work.

Hi Paulie, Im new to flow. Can you work in the same way with outlook attachments?

How do you get text from variables that don't always have the same amount of characters or additional lines, such as a description box?

Great video! Not sure what I did incorrectly but my output is wrapped with a [" "] Is there a way I can get rid of those extra characters? I'm trying to parse the info out of an email and store it in a SharePoint list.

How do you extract data without having split function? I want to extract data from a zero element

5 start rating for you Paulie. First time to your channel and approach is mazing. well done. Can you do a video on how to search for a value in the invoice data excel and turn to Power Virtual Agent. for example, i query PVA with invoice no, i want to know the amount and when it is due. thanks

Hello Paulie - Brilliant explanation - Do you have a video explaining how to extract a CSV or Excel file from a URL in Email and save it to Sharepoint? Kind regards. Tim

why do i not see the little option to access expressions/ dynamic content in the normal viewier?

How to get multiple values for an attribute into excel rows? Could you elaborate on that?

Thank you for a great video. Very useful. However, I stumbled upon an issue. The result I get from the filterArray action varies due to slight differences between the emails received. Which means that the value corresponding to the line position used in split(body('Filter_array')[5], ':')[0] varies slightly between emails. In this case, sometimes it's 5 other times it's 6. Is there a way to include within this expression a function to find the line number within an array for a specific string? Thanks a lot

Great video. First time I've even considered using Power Apps and it works a dream. Thanks. However, the emails I want to use this with have the same content every time, although if the customer has a long address it sometimes throws the individual lines onto an extra line, so the slit into lines part will sometimes have different line numbers. Do you know if here is a way around this? Hope that makes sense.

I get this error: Cannot read properties of undefined (reading 'properties')

Hi @Paulie, I am trying to parse email to html text and wanted to include subject line, input it takes subject line but output getting only email body without subject line. Would you please guide me

Hi Paulie, excellent video very useful for me many thanks. I have a question, i am receiving an email which is a completed form. From it i need to extract the mobile number, email and name. However as the length in responses varies from the senders the email is never the same. Is there a way i can specifically search for a value in the email body and extract it out? I need to pull out the 3 separate values, which always exist but using an array won't work as they won't always be on the same line.

Hello, Thank you for this, do you have an idea if this would work for a shared mailbox? Im thinking to use this in a case where I have several shared mailboxes or alternatively use one mailbox but with different alias addresses mapped to same account.

Hi Paul, I want to use this conversion with Get Email, but it is returning blank value. can you please help

HOw would you parse multiple lines? I have an email and starting at line 5 to the end(which is variable) are the same

on video you said that on automate the line start from 0 and from 1 on notepad, and you are right, so on you how is works for for examle on InvoiceID why you put 5 and no 4 ?

if there are any other characters after that invoice id how can we capture only the ID. example if it was "invoice ID: 12345878 has been submitted". Please reply.

Great video. It looks to be just what I needed. However when I try to follow the steps. After I add the "new email arrives" I add the HTML to Text - but for some reason it marks this as an " Apply to each" action not a seperate action with the action name (HTML to text). there is an add action to this (like it is nested or add action below - I choose the later - I add the compose for new line. I then do the new compose - I type in the expression - but then under Dynamic Content I don't see the "HTML to Text" and body outputs. It seems like this "apply to each" is causing a problem - not sure why I am seeing it or how to change it to a normal action. The subsequent ones I nested under the apply to each and then I could get the steps but it fails at that first "apply to each - ActionFailed" It seems to get to splitIntoLines - and gets "InvalidTemplate. Unable to process template language expressions in action 'SplitIntoLines' inputs at line '0' and column '0': 'The template language expression 'split(body('Html_to_text')?['body'],outputs('NewLine'))' cannot be evaluated because property 'body' cannot be selected. Property selection is not supported on values of type 'String'. Please see aka.ms/logicexpressions for usage details.'." - that line looks like "split(body('Html_to_text')?['body'],outputs('NewLine'))" - This is what it looks like: democompany.studio5d.com/microsoftflow.png

Thank you so much. I want to send an email to respective recipients, and I would like to include some data from the incoming mail (main trigger). Any idea would be appreciated.

Good video. Slow it down next time, please.

This has been very useful!! I do have a question about trying to extract multiple IDs. Use Case: Receive an automated email that will list ALL of the updates for items that day... can have a variety amount of items in this email list, so, not sure if i'll be able to figure out what exact line the info will be at. After receiving, I will need to then update my own Sharepoint List with those updates for items listed in that email. How do I extract each of those items and subsequent relational data (eg: Status, Priority, Due Date) then, update a SharePoint list with those variables? For instance, received an email for with updates *ID: 1, Status: In progress, Priority: high, Due Date: 12/2/2023 *ID: 2, Status: Complete, Priority: critical, Due Date: 8/3/2025. (* is a bulleted list). I will then need to take those two IDs and compare it with my list to see if it is there, and if it is, I will then want to update those items. Thank you!!

This is a great tutorial as it has helped me understand flow better. I am working on a flow at the moment to get some information from an email but what im trying to get is a variable. it could list multiple service ID's or it could list 1 service ID on the one email. how would you get that from an email?

Good one! Any video of how to extract some attachments from email and maybe extract the content of them? like from .zip files?

This is fantastic video. It was the first one I watched and i haven't found anything better. However I'm still struggling to extract the data I need. When an order goes through I get an automated email which has the key information in the middle of lines. I'm not sure to do to get only that information.

Paulie, I am stuck at the first Compose. It appears you don't enter any Input but PA is requiring an Input. Could you let me know what you did in that step?

Really superb tutorial. Do you know if it's possible parse the text without using the line number, only the text that should match? In my example, I want to read the content after the "E-mail:" string.

Great video, thanks for this. Would this work in 2022 because Microsoft makes updates.

With the expressions in your example, how do you handle blank values? I've been trying to wrap my head around this for hours, and Google has been no help.

How to extract multiple rows from a single mail? For example: one mail has details of multiple invoices. Can you show that loop?

Hey Paul, great videos! I’m having trouble with my flow and keep getting error messages. I want to import data from an email but the data isn't always on the same line, for example having multiple order numbers set out like this: Order number: 1234567 5678910 How would I get everything imported to excel between where it says order number and the bottom of the email template which says ‘thanks’? Thank you for any help given! Really appreciated

Hi! Sorry to bother you, but I'm having a problem with the 'Split HTML to Text' action in my flow. Three weeks ago, I created this flow with specific instructions, and it was working fine. However, now the 'Split' and 'Filter array' actions are not working as expected. I've followed all the instructions, but the flow still doesn't work correctly. Could you please let me know if it's possible to contact you to discuss and troubleshoot this issue ?

Hello, I am also a newbie to power automate. Is there a way to find a random 4 digit numer in an email subject like "0123" or "5428"? I assume Split won't help me because this string can be in any place of the email subject an there is no delimiter. This 4 digit number is an additional key of a Ms Dynamics 365 entity and I would like to create an email activity and set the correct regarding in Ms Dynamics 365 if the eMail contains a number that exists as a key in MS Dynamics 365. Thank your very much für your help...

What do you mean "I want to get rid of the empty output" at 1:36? Thanks

Hey paulie, thanks for sharing this video, i have a question, if the emails comes in in different formats from the customers say if it is an unstructured email text, then will this method be valid and also can this data be used to auto-populate directly into web applications. Kindly share your valuable feedback on this. Thanks!

thank you for sharing! do you have article for this?

what if i receive email in text format rather then the HTML format

Good video but wow! Slow down next time

Json Parsing table format email

I tried to understand but this tutorial is way too involved...

Fantastic. Question I have followed your instructions but have just one item that has 03456\" and I can't get the " out. replace(split(body('Filter_array')[1],' ')[4], '\”', '') The rest worked perfectly. You saved me hours of work.