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.
@faishala4949
14 күн бұрын
Hi, I would like to ask, how can the unique code in the email subject (e.g., 00015) be used as a trigger to find a folder with the same name in SharePoint? 1. Email arrives (with the unique code in the subject). 2. Save the email and attachment as a .eml file. 3. Save the .eml file in a folder that already exists in SharePoint, with the folder name matching the unique code in the email subject. I greatly appreciate the information you are going to provide
@abm4975
14 күн бұрын
Hi Thanks for the question and support. Follow the below steps: 1. After the outlook trigger, add an action step called Create new folder. 2. Next action step Export email. Here pass the Message ID from the trigger. 3. Finally use the create file to save the email body to the specified folder we created earlier.
@rubenpuertosmartinez
6 ай бұрын
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
@darkspeed62
Жыл бұрын
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?
@abm4975
Жыл бұрын
Hi Thanks so much for the support. I was away for few weeks. Do you still need help in this please? Thanks
@dernamenlose13
Жыл бұрын
Yes please, can u do a video and i like to extract the data into excel. Thanks for your help!@@abm4975
@dianafs7429
6 ай бұрын
Hi I need help please. I have the same request@@abm4975
@sujithasureshbabu4589
Жыл бұрын
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?
@abm4975
Жыл бұрын
Hi Thanks for the question. Could you add an If condition to check whether its null?
@sujithasureshbabu4589
Жыл бұрын
@@abm4975 Thank you, it worked ! :)
@MalcolmBritt-l8z
Жыл бұрын
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.
@abm4975
Жыл бұрын
Hi Please have a look at this video from Damien. kzitem.info/news/bejne/ymp9rnd9hnN1a20
@talandria_digital_learning
Жыл бұрын
Good. Tutorial 😁
@abm4975
Жыл бұрын
Thank you! Cheers!
@akhiljohn4145
Жыл бұрын
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
@abm4975
Жыл бұрын
Hi Akhil That will be difficult. You need a pattern of data then only you can apply the rules how to extract the data. Thanks
@thewanderingcouple8378
Жыл бұрын
Can we extract the value by using AI builder and use the last(split expression to get only value and create sharepoint list items with the value?
@abm4975
Жыл бұрын
Hi You could try it. Why you need to use the AI builder? Thanks
@cristobalramirezvalderrama790
7 ай бұрын
Hello, if I have a line from the message body that contains the text string "xacd" how can I get the entire line?
@abm4975
7 ай бұрын
Hi Use a split() expression first to get each lines into an array. Then check "xacd" contains.
@cristobalramirezvalderrama790
7 ай бұрын
@@abm4975 thanks master ❤️
@abm4975
3 ай бұрын
Thanks
@stephanieyang9168
Жыл бұрын
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
@abm4975
Жыл бұрын
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.
@hakisterplays
Жыл бұрын
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
Жыл бұрын
Hi I was away for few weeks. Do you still need help in this please? Thanks
@albaharh
Жыл бұрын
@@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 :)
@SravyasPassion
Жыл бұрын
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
@dernamenlose13
Жыл бұрын
Same here@@albaharh
@victordauden9173
Жыл бұрын
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!!!
@abm4975
Жыл бұрын
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
@victordauden9173
Жыл бұрын
@@abm4975 thank you. Your content is unparalleled. The time you take to answer and explainin each video. Hats off to you @abm
@abm4975
Жыл бұрын
Thanks a lot Victor. Really appreciate your kind comments.
@SreeramSashankChundi
2 ай бұрын
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
@gedelasaisravya2603
7 ай бұрын
How to extract address field from a pdf which has different number of lines(2-5) for each person?
@abm4975
7 ай бұрын
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
@deebantech
11 ай бұрын
Hello, I wanted to extract email addresses from the body and put it in array. Please help me out with the steps..
@abm4975
11 ай бұрын
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
@TopRankDnB
Жыл бұрын
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?
@abm4975
Жыл бұрын
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
@marcussoh8445
Жыл бұрын
Hi what if the body is like to name: nameof the person how should I adjust the expression?
@abm4975
Жыл бұрын
Yes that's correct.
@tonya3308
Жыл бұрын
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
Жыл бұрын
Is that image reference is a url? Thanks
@tonya3308
Жыл бұрын
@@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?
@abm4975
Жыл бұрын
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?
@JoseLuis-jn6ge
11 ай бұрын
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?
@abm4975
11 ай бұрын
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
@JoseLuis-jn6ge
11 ай бұрын
Hello, thank you very much for the answer, its sounds quite difficult, I will try to do it. I am new to this world of programming.
@abm4975
11 ай бұрын
Hey I could offer a screenshare. Check my channel about section and join via teams. I will have a look into this. Thanks
@adagonzalez3241
Жыл бұрын
Would of be possible to modify this flow to ensure that the entire email message is extracted except the greeting line end ending line of the email?
@abm4975
Жыл бұрын
Hi Thanks for the question and support. Yes have a look on Power Automate skip() expression. Thanks
@user-hv3mf8qk4j
4 ай бұрын
Hi I want to store the first 500 words from the body of the mail in share point list how can I ?
@abm4975
3 ай бұрын
Hi Use the expression substring('your email body', 0, 500).
@user-hv3mf8qk4j
3 ай бұрын
@@abm4975 thanks
@MrMrasimdafnqalbi
Жыл бұрын
Thanks dear. What about if I want a specific item in the array? let us say number 15?
@abm4975
Жыл бұрын
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
@jnibur
Жыл бұрын
very nice video...and how to extract a table from outlook email and paste into excel?
@abm4975
Жыл бұрын
Have a look at this video kzitem.info/news/bejne/ymp9rnd9hnN1a20
@vastavchandrakesh
Жыл бұрын
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
@abm4975
Жыл бұрын
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
@arthurpurcino5
Жыл бұрын
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.
@abm4975
Жыл бұрын
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
@bayutrianayasa5663
10 ай бұрын
Can u show how to export multiple body email to excell with power automate?
@abm4975
10 ай бұрын
Hi Could you explain with an example please. I could look into it. Thanks
@jayashudhaanand1781
10 ай бұрын
How to extract email address from subject of an email
@abm4975
10 ай бұрын
I need to see a sample format of the subject. Are there any specific patterns in your email subject? Thanks
@benjaminfoley919
3 ай бұрын
The enter key part doesn't seem to work for me
@abm4975
3 ай бұрын
So that means in your email each lines are not recognized as enter keys. Is that email generated by other systems?
@benjaminfoley919
3 ай бұрын
@@abm4975 Its an automated email generated by a failing machine. But its structured when the email arrives.
@abm4975
3 ай бұрын
I need to see your flow. If you ok for a screenshare then see my About section. Send me an email. Thanks
@sarahrahimahothman1838
Жыл бұрын
Hi, this is a fantastic solution! I solved my issue with this video. Do you know how to store this multiple rows in one row of sharepoint list?
@abm4975
Жыл бұрын
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
@sarahrahimahothman1838
Жыл бұрын
@@abm4975 Can you show how to do it? I cannot imagine where to add extra function in the flow. Thanks
@abm4975
Жыл бұрын
Hi If you still need help connect me via teams. Have a look at my channel about section.
@sadhals6950
Жыл бұрын
Hi I need to extract tables from email, can u pls hlp....
@abm4975
Жыл бұрын
Hi Thanks for your question. Damo got a good video about this. Please have a look. kzitem.info/news/bejne/ymp9rnd9hnN1a20 Thanks
@hosyaarchand
7 ай бұрын
only enter is on working, its taking space but not enter
@abm4975
7 ай бұрын
Hi It should work for both. I need to see your flow. If you still need help check my channel about section and contact me. Thanks
@srambade123
Жыл бұрын
Hi, this is awesome solution but i need to take rows instead of columns what i need to do?
@abm4975
Жыл бұрын
Hi Thanks for the support. Is your email body data in a HTML table? If not provide an example of data.
@srambade123
Жыл бұрын
@@abm4975 Yes, it's html table in email body. Columns are fixed but rows get added as and when data is updated as per new mail received.
@abm4975
Жыл бұрын
Hi Apologies for the late reply. Have a look at this video. kzitem.info/news/bejne/ymp9rnd9hnN1a20 Thanks
@MSDQ_Creations
Жыл бұрын
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.
@abm4975
Жыл бұрын
Hi Muhammed Use the last() and split expression to get the value last(split('process - Request Nr. 28753','Nr. '))
Пікірлер: 86