This video explains how to extract body of email which contains multiple rows. Expressions I used in this video is as follows: split(outputs('HTML_to_text_2')?['body'],outputs('Compose_2')) last(split(outputs('Compose_4'),'Name:'))
Congratulations, great video! What about if I have the values in separate rows? E.g. Row1 = Name; Row2= Will Smith. is there any way to pull the information from the 'Apply to each' as I will always be receiving the same form
thanks for sharing, I have a question on the same, if multiple parameters has to be extracted from the body like say in this video , in the yes condition box if we have extract age and gender how do you write those conditions and if the data is unstructured say if mails are received in different formats(instead of semi colon, a dash is used or details are mentioned in a single line) what method can be used. kindly respond! Thanks
This video is really usefull to me...Thanks for video... need one more help from you .... I have mail with the table in body that body table need to extrext and share some line item to the other user via mail by using power automate.
Hello, Thank you for these! I am trying to do this, but when it comes to the expression split, it says that it does not exist.. is there another expression that does the same thing
Hi Click the expression tab and type split(). Believe your cursor focus is under the Dynamic expression. Have a look on my video carefully. Split() do exists.
This video is really helpful, and I love how you show the outputs at each stage so it makes more sense what you are doing. I am however confused as to how you extract more data after the true/false conditon. So, I got Irene. How then do I extract 54 within that condition, and then Female?
Hi, this is excellent - I have a question if you are able to help. I would like to take certain values, loop through and add them to a row within excel, the format of each email is the same but when converted to html to text looks like: First Name Username1 Age 23 First Name Username2 Age 24 Not like your example which is: First Name: Username1 Age:23 First Name: Username2 Age: 24 I have an excel table which should update each column with these values received, and add a new row for each person’s info. You mention a ‘concat’ at the end of this video which may be a starting point for me?
Hi I need to see the flow to comment on this. Could you please post in Power Automate Community and tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
i have created a flow where when ever we receive an email(v3) the automation will copy the body and paste it in an excel sheet . but when i receive 2 emails at exact same time the flow is unable to trigger both the emails but only one some times none can you help me with this
Super cool! I'm trying to extract just a few lines on top of a HTML table from an email received jsut ike this example you showcased, such as Customer, Invoice No.. etc. Then the table, headers Currency, Item and so on and then the content of the table itself. Any thoughts on that? thx!!!
Hi Victor Thanks for the support. So again here you have enter key or new line as separator. split('email body', 'EnterKey'). Please see exact syntax in my video. So that means it will create an array After the array you can access the first index to get Customer and next index to get Invoice No Below is the expression to get customer split('email body', 'EnterKey')[0] For invoice split('email body', 'EnterKey').[1] Hope it makes sense. If you need further help please let me know. Happy to help. Thanks
how would this work for an email that sends informations in a table? I want to extract the names of the headers, and the information listed below each.
This video and the other one on unstructured were really useful! Saved me lots of time & effort. I have put them in a sharepoint list. There are a lot of null values before the desired result and after the desired result. Ex: [null,null,Sujitha, null,null]. Could you please let me know a way to update this without the null values?
Hi Ali If you are looking for a specific item, you could add an IF condition to check the name of the item and get the specific value. Another way is using the Filter array and check item value is 15 or not? It's all depends on your data. Thanks
I am using PowerAutomate to export emails to a database and then display the data in a PowerApp gallery depending on customer needs; however, many times the customer emails have pasted images and screen shots in the email. I cannot get these images to appear in a PowerApp gallery - the email text displays but the image is blank. Any ideas? I have tried using the Html text box in PowerApps as well as the Image control without any success.
@@abm4975 In my situation, the customers have a few sentences of text, then an image they pasted into the email, maybe a few more sentences, one or two more pasted images and then maybe another sentence or two. Via power automate I save the email (based on subject content) to a sql table and save the body as varchar(max) - then the customers are able to view the email, based on filter criteria, in a powerapps gallery; however, the images do not show. I believe they are a cid and I cannot figure how to (1) make the image show in the gallery (I believe this may not be possible), and (2) how to enable the customer to click on the image url and view the cid by clicking on this email body in the powerapps gallery. Thoughts?
Thanks for your reply. If the images are coming from a url reference then it might be possible otherwise you need to store the images somewhere. I am not sure how to store the email embedded images?
Hello! I have a question about e-mails that I cannot solve, but for me it seems pretty simple: Can I respond an email that my power automate flow made for me? Like: My flow sends an e-mail, and after a specific "If" function, It'll answer the e-mail for me with another message, like starting a conversation.
Hi There are no send reply action button. What you could do is get the email body from the trigger and map it in your send email action step with your custom reply. Thanks
I don't think its supported by native connectors. You may need to look third party connectors within Power Automate. There are few out there already. Thanks
Hello Ajith. Thank you for this video. It gave me an idea on how to parse the body of the email into text. I do have one question though. Let's say instead of just extracting the name, I want to extract age and gender as well, how do I go about doing that in an Apply to Each action? I'm planning to put them in one row in an excel spreadsheet table.
@@abm4975 yes please, can you show us how to extract the age and gender and other values and store each value in separate column in a list please ?t I've been hitting my head into a wall on how to iterate more values It would be appreciated and Ill subscribe and like your videos to :)
Hi @abm abm, Thanks for your valuable content, Even though I have the same doubt, Could you please share a flow on how to concat the values from an email body and add them into single row in a excel file
Hi... I get mail which has all the data can i add a filter to it and project what i needed in teams if yes can you please help me with the process ... Thanks
Hi Could you please post in Power Automate community forum. Explain using an example. Tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Building-Flows
Hi I need to see a sample of text? Is the email under the body is always going to be in same position? If its in different place its quite difficult to extract it. For extracting the data you need the data to be placed under a specified format. Then we can apply those rules to get that particular data. See an example below of a body format: 1. Name: David Smith 2. Email: d.s@test.com So for the above we can look the second line and extract the email using Power Automate. Please tell me more about the email body of yours? Thanks
Hi You could add string (variable action step) and use append to string to append all the values. Finally use this string variable to update the row of SharePoint list. Thanks
Nice video, It is possible to classify emails and extract information only on emails received on business days and business hours excluding weekends and holidays and then send a Teams message to a Chat or group?
Hi Thanks for your question. Yes you can. Mail trigger got a value called 'Received Time'. This holds the datetime value of the email you received. You can check using the expression called 'dayOfWeek()' Here passing the Received Time from the trigger. This will return 0 for Sunday, 1 for Monday and so on. Add an If condition to determine if its a weekend or not and use Terminate action step to stop the flow. Again for checking the business hours you need to parse the Received Time using formatDateTime() expression. eg: formatDateTime('RecivedTime from the trigger here', 'HH:mm') This will return the the hours and minutes in 24 hour format. Again add a check to determine if its more than 17 (5 pm) then terminate the flow. You could add all these as one expression under the trigger too. Its a bit complicated. If you need further assistance let me know. Happy to help you via a screenshare. Good luck. Thanks
Hi Thanks for your question. Damo got a good video about this. Please have a look. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i4GHCGMAD88.html Thanks
In an email, how to extraxt a specific text in between other characters (in a constant email format), example: process - Request Nr. 28753 has been submitted for your review. and i need only the request number.