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: ua-cam.com/video/yOl9B7k58KU/v-deo.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: ua-cam.com/video/WvzMe_yTaz8/v-deo.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?
Check out how easy email parsing is using Power Tools for Power Automate in this video: ua-cam.com/video/WvzMe_yTaz8/v-deo.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:
ua-cam.com/video/yOl9B7k58KU/v-deo.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:
ua-cam.com/video/WvzMe_yTaz8/v-deo.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!
What a lovely and encouraging compliment - thank you!
@@PaulieM this is true. I found your tutorial really amazing.
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.
I really like the Parse JSON approach, you start to explain at 11:36
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.
Really pleased you found it helpful - thanks for the feedback. 👍🏻
After searching many video, finally I can manage created list from email body text.. Tqvm Paulie.. Appreciated..
Thank you for the feedback - much appreciated
Great stuff Speedy Gonzalez, thank God for pause/rewind but I like your approach.
Finally I have found something that can help with an email / automate problem I have. Thank you!!!!
You taught me much more than any crappy video out there, gem of a tutorial ❤️
Glad the video was helpful, well done. 👍🏻
@@PaulieM ❤️ I am the one from, LinkedIn 😉
I was tyring to get this with god know how many function...non worked...this has absolutely solved, thanks a ton !!
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!!!
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!
So pleased to hear it! Well done!
Thanks a lot for sharing very helpful tips and tricks
My pleasure 😊
Hi Paulie, thank you so much for this tutorial. This 'newLine' trick is very impressive to a beginner like me.
Hi Paulie, Thank a lot for sharing this video.
No worries - glad it was useful to you.
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.
Thanks man. Learned a lot of from this and helped me complete a task.
Thanks for the tutorial, this will be great for what I want to do.
Would love to see how the Excel Sheet would look like ^^
Clean and concise. Nicely done.
Thank you Julie
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
Which parts went over your head? I can do a video explainer for those parts.
@@PaulieM an explainer video might take you back a bit, rather let me try an catch up, thanks 😊
Brilliant tutorial! Thank you
Thanks for the feedback - glad you found it useful.
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.
Amazing!🎉 Thank you for sharing your knowledge!👏
Thank you for the kind words. Really pleased that the video was useful to you.
Simply amazing. Exactly what i needed. thank you alot.
Wonderful and extremely useful. Thanks a lot!!!
Just what I what looking for! Thanks!
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!
Very pleased to hear it! Reach out if you need anyting.
Thank you so much. It's amazing.
I learn a lot from your videos.
Great thanks to you sir
Great explanations, it helped me a lot, many thanks and Hayppy New Year !
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?
Amazing video, very grateful
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 tutorial is great 💥💥💥
Good video. Slow it down next time, please.
hi, thanks for the tutorial, please explain why compose empty, and deleted the line "0" at the notepad
Thank you so much, this was so helpful!!!
Great stuff! Thank you for sharing...
Great video, thanks for this. Would this work in 2022 because Microsoft makes updates.
Hi Big Ship - It should do, nothing used in this video has been updated or changed since it was published to any significant extent.
@@PaulieM great, thanks so much, I’ll try it👏
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?
I would probably use an AI service. But you could also do it with a refinement of the method in this video by examining the length of lines etc.
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!!
Reach out through my blog and I will see if I can help you out. Away for a few days though.
@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?
thanks.
Thanks a ton, great great work. Genius.
Good one! Any video of how to extract some attachments from email and maybe extract the content of them? like from .zip files?
This video helped me a lot, thanks!
I’m very pleased to hear it. Thank you 🙏
Thx a lot nice way to parse html email :)
How to extract multiple rows from a single mail?
For example: one mail has details of multiple invoices. Can you show that loop?
If you get in touch via my blog, with an example email, I will provide an explanation.
Did you resolve it?
@@evelynjgonzalez we didn’t try. Do you have /ma similar problem?
@@PaulieM Hi, I also have a similar problem. Did you guys resolve it? :)
@@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.
Good video, it helps me to good start. 😊👍 Can you tell me Attachments of the mail how you are parsing through flow
why do i not see the little option to access expressions/ dynamic content in the normal viewier?
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 ?
Power Automate arrays always start from zero.
Thanks 🙏🙏🙏
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.
Yes, it would work in the same way for a shared mailbox. The trigger output is almost the same.
Thank you! Create explanation.
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.
I don’t think I understand what you mean perfectly, but you could try using regular expressions:
www.tachytelic.net/2021/04/power-automate-regex/
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.
Hi - if you use the contact form on my blog I will help you out.
@@PaulieM Oh amazing! Thank you!!
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
How did you resolve it? I'm facing the same issue too
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?
@@DavidVerzolla it’s possible in Logic Apps. But I’ve not seen or heard anything in regards to Power Automate. Which is a shame.
Exactly what i wanted
HOw would you parse multiple lines? I have an email and starting at line 5 to the end(which is variable) are the same
Combine the length expression with the range expression and the select action to go through every line from line 5 dynamically.
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?
can we use this method to record and move the old mails to excel?
Hi Paulie,
Im new to flow. Can you work in the same way with outlook attachments?
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 ?
You can contact me via my blog for help:
www.tachytelic.net/microsoft-power-automate-support/
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.
If you’ve been struggling for a long time. Fill out the contact form on my blog and I will help you out.
@@PaulieM Contact sent. Thank you so much for taking a look!
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.
@@PaulieM Thank you for sharing your response. much appreciated!
How to get multiple values for an attribute into excel rows?
Could you elaborate on that?
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"?
@@PaulieM it could be both, "1234" could be in any place in the subject of the mail
Hi Paul, I want to use this conversion with Get Email, but it is returning blank value. can you please help
I get this error: Cannot read properties of undefined (reading 'properties')
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?
I see you entered an empty Return... got it... thanks
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.
Hi Chinwe, if you get in touch through my blog I will see if I can help you out. www.tachytelic.net/get-in-touch/
@@PaulieM Hi Paul, I just submitted a request. Thank you.
Good video but wow! Slow down next time
Sorry! Will remember that for next time and try to take it a bit slower.
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
How do you extract data without having split function? I want to extract data from a zero element
what if i receive email in text format rather then the HTML format
Then you skip out the HTML to Text action and continue with the flow.
@@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
thank you for sharing! do you have article for this?
Not for this video, sorry. What information are you looking for?
What do you mean "I want to get rid of the empty output" at 1:36? Thanks
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.
@@PaulieM The question was about the new line right after the Html to text. Why the blank line there? Why do we add another blank line?
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
You could enhance the expression with an if statement and use indexOf to test if your value is present and then extract it.
@@PaulieM Thank you very much for the suggestion. I will give it a try.
@@RachedMaalej were you able to find a solution for the same? Please respond,
thanks
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.
Json Parsing table format email
I don’t understand ?
@@PaulieM sorry how to parse the table content inside email using json
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
@@sankarann it’s possible and I did cover it in a recent video. But I’m going to re-film it and go into a bit more detail.
@@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?
I tried to understand but this tutorial is way too involved...