Check out how easy email parsing is using Power Tools for Power Automate in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WvzMe_yTaz8.html
Thanks for the video. I. New to this but in my case the rows in arraycould change .. any way you can search a string in the array instead of the row no?
@@leejohmmathew yes, you could use a filter array action to search within the array for the value you’re looking for. Alternatively check out this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yOl9B7k58KU.html Which shows how to do it using a regular expression. Also this video is a useful example of parsing an email with regex batch method: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WvzMe_yTaz8.html Let me know if you need guidance with the filter. You can post a question on powercoders.net with your flow.
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!
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.
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.
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!!!
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
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
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.
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!
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?
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.
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?
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!
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!!
@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?
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
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
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?
@@picapica9 I don't remember about this one in particular, but I have helped a bunch of people with this in a teams sharing session. Reach out via the blog if you need some help.
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 ?
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, 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
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
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 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.
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.
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
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.
Yes, you would split the whole string on E-Mail: then you’d have an array, the second element of which would be the email address and anything that comes after it. You could probably split what remains on a new line and you’d have the email address.
@@PaulieM Awesome. I have followed another link you sent, showing how to use regex. In the video, the author use Excel Scripting (javascript). I wonder why Microsoft does not use javascript (or any other language) to enhance power automate straight inside it. Have you heard | read something about this?
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.
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 ?
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.
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.
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.
There will be a workaround, best thing to do is to generate a sample where the line wraps, then show me a sample. You can get in touch via my blog and I might be able to take a look for you.
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!
Yes, you could use this technique. Parsing from emails is always tricky as they are somewhat variable in nature. But if you are parsing emails that are automatically system generated then I think it would be ok. If you need something more sophisticated then I would consider using mailparser.io/ it is a great tool.
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.
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...
I think I would be tempted to use a regex in an Office Script to grab the 4 digit number. But it would also be possible to do it with standard Power Automate actions. Although not super straightforward. Would the subject line be something like "Test Subject 1234" or could it be "Test 1234 Subject"?
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?
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.
Thanks for the reply. I'm looking to setup something essentially the same. Take inbound email from a specific address, extract certain data from the body, and populate a spreadsheet. If you have anything you can forward to get me going that would be helpful
@@PaulieM thanks for getting back.. here in your example array is constant. what happens if the array position keeps changing. eg: email1: l1:2:3 l2:3:4 email2: l1:4:5 how can i extract all l1 and corresponding values into excel in one step
The HTML to Text action may well produce a lot of empty lines, so slightly further on in the video all of the empty lines are removed by using a filter. The purpose of this is to make further processing easier. But you could, if you wanted to do so, leave the empty lines in.
Not sure if you know, but I just had the same question and listened instead of watched lol.... He clicks in the cell and hits the enter key. Then it allows it to "see an input" so the requirement is gone. Took me a minute to figure it out also.
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
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 Emma, sorry I didn't see your comment. If you're still stuck reach out to me through my blog www.tachytelic.net/get-in-touch/ and I will help you out.
Same question - the email I get contains name, phone, email address and comments formatted as a table in the body of the email. There is no separator like - or : in the table. Values that need to be captured are in a separate column. How can we parse that information into excel? 7 rows in the email needs to be transposed to 7 columns of a single row in excel
@@PaulieM thanks. I am a novice at this. I tried the filter array which listed the items in individual rows on the output. Now I am trying to fetch the value in a specific line (example - value in line 5) without using the split expression. How can I just take the value and publish as an output for a compose action?
