Power Automate - Extract Text Values from Email!

Подписаться 885

Просмотров 36 тыс.

50% 1

Learn how to extract text values from emails using Power Automate. With this flow you can even achieve system integrations that would otherwise be impossible without API.
Expressions used:
Split Body Text: split(body('Html_to_text'),outputs('EnterKey'))
Compose: Name: last(split(outputs('Split_Body_Text')[6],': ')) (Where "6" equals the row of the output array of the value you want to extract)
More Power Automate videos here: • Power Automate
Intro to Power Automate Cloud Flow series: • Intro to Power Automat...
Need help implementing this flow? Let’s connect! www.jeremybarden.com/automati...
Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden
#rpa #powerautomate #outlook #integration

Опубликовано:

31 май 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 64

@caleybell2385 11 месяцев назад

Thank you so much for this, I have watched heaps of videos trying to achieve this and yours was the clearest - I finally got the result I needed!

@kyowakore27 4 месяца назад

This is exactly what I needed to implement. Great tutorial. Thank you!

@jibbsautomations 4 месяца назад

Thank you!! Glad it helped!

@laszlogyor6628 День назад

Awesome video, thank you.🙂

@cainweo 9 месяцев назад

Man you saved my life ! thanks a lot very straightforward

@allison7324 4 месяца назад

This is an amazing tutorial! Thank you!

@RolandoNispiros 9 месяцев назад

Awesome tutorial, thank you, this helped me!

@pupu937 6 месяцев назад

Excellent content, thanks so much!

@beprovidelo 3 месяца назад

Great Content! Warm Regards from Brazil! :)

@mhsea 24 дня назад

Excellent method and tutorial; thank you so much 😊🙏

@ignaciovaldesfernandez3908 5 месяцев назад

THAK YOU!

@xnom0201 8 месяцев назад

Excellent

@MaxineInUuPoep 2 месяца назад

Hi! Thank you for this video, I'm doing the same steps but in the Compose step I get this error: The input parameter(s) of action 'Compose' contain an invalid reference to 'Split_Body_Text'. Correct to include a valid reference to 'Split_Body_Text' for the input parameter(s) of action 'Compose'. Not sure what I'm doing wrong?

@jibbsautomations Месяц назад

Sorry the late reply. Usually I see this error when my action title is rewritten and subsequent steps using dynamic content are not automatically updated by PA to reflect this. That might not be what's happening to you, but if you haven't already, please post in Community with screenshots and feel free to tag me @Jibbs

@chowdaryjaladi4015 2 месяца назад

last(split(outputs('Split_Body_Text')[6],': ')) This works but , i wanto to get the output of the lines from 4 to 10 , what is the expression for that?

@jibbsautomations Месяц назад

Hi, thanks for posting. You should just need the same expression but change the line (in my example "[6]") to whatever line number you need.

@RolandoNispiros 9 месяцев назад

Can you tell me how to only strip out text between words? For example I just want the word 'Financial' to be the output result from a place in the body of the email that has '2022/23 FY Financial Control Audit'. When I use the 'Last' expression and Split Body Text like you showed, 'last (split(outputs('Split_Body_Text')[11],': ')), as an example, I get a full line of other data, including the word(s) I wanted.

@jibbsautomations 9 месяцев назад

Hi Rolando, I think abm has what you are looking for in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-62BB3rpe37g.htmla Hope this helps!

@pebkaclive 6 месяцев назад

I get the following error: Unable to process template language expressions in action 'SplitBodyText' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'. Any thoughts?

@jibbsautomations Месяц назад

Sorry the late reply, if you haven't already, please post in Community with screenshots and feel free to tag me @Jibbs

@PollynzDataTech 5 месяцев назад

Thank you for the video, could you help me on the issues I am having. The EnterKey compose is not working for me, it is saying "This filed is required"

@jibbsautomations 5 месяцев назад

Hi, thanks for posting. As long as you are hitting the enter key in the compose action field, it should not give you an error. Can you post in PA community with a screenshot so we can see what you are seeing? Thank you!

@maximumtaste_ 3 месяца назад

I hope you see this in time, but I have the issue that all of the data is in one single line and I have a different output of data in every different e-mail

@sethohler 3 месяца назад

Depending on what you're doing, you may need to add line breaks (html) between the variables for each piece of data you're extracting. But if you're sending it off to a spreadsheet, I would dump it there as is, split and format the data in another sheet or range.

@jibbsautomations 2 месяца назад

Hi, sorry the late response, if you are still looking for a solution, you could try this video by abm: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k6O3ZH71Jc0.html Or this video by me which uses AI builder in the flow: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k6O3ZH71Jc0.html

@hariyalipatel3988 11 месяцев назад

Amazing video. I have word document and want to copy in email body in same format as it is in word document. Is this possible in power automate?

@jibbsautomations 11 месяцев назад

Hi! Yes, this should be possible with a power automate cloud flow. I put it on my future tutorials list. In the meantime, you can try by using the get email, create file (such as word doc in SharePoint), and then if needed, a modify action(s) to correct any formatting issues.

@ultracamp 22 дня назад

How come the Compose Split Body Text is required? The input and output look identical in the test?

@peterchu2669 3 месяца назад

Thanks for this wonderful tutorial. My problem is when I compose for the Company name, I get this error: Property selection is not supported on values of type 'String'. I think its because my emails that I work with have pics, and Links. I cant seem to discard those, even if my first compose after the HTML_to_text function is a split function, essentially I get errors Whats a nifty way to remove all URLs after the Html_to_text function?

@jibbsautomations 3 месяца назад

Hi, great question. I have not encountered this issue, so I would suggest posting over in the Community, if you haven't already. You'll likely get some good suggestions there!

@cedielaban3410 11 месяцев назад

Hi! This is great content. Similar to this, I wanted to create a flow as well to transfer a data from email and tranfer it to MS Excel. However, my data in the body of an email is in table form. Is there a way?

@jibbsautomations 11 месяцев назад

Hi! I havent tried this where the email body is a table. Do have any control over the email and can remove the table? If not, it might still be possible to capture the text, but you might have to play around with the expression first.

@reinerraudzus80 10 месяцев назад

Did you figures it out?

@user-oj7cl4qq9m 10 месяцев назад

Very helpful and have spent hours over the past few days trying to figure out how to do this exact function with no success until your video. Just out of curiosity, what is the point of the "EnterKey" action?

@sujithv92 9 месяцев назад

I am curious too lol

@jibbsautomations 9 месяцев назад

Hi thank you for posting. As I understand it, the EnterKey action is to identify new lines from the email body.

@zzexp 2 месяца назад

I do not have any actions under 'Content Conversion' anyone know why?

@jibbsautomations Месяц назад

Hi, were you able to find the action? Here's the documentation on the content conversion action: learn.microsoft.com/en-us/connectors/conversionservice/ If you are still not seeing the action, please post in Community with screenshots and feel free to tag me @Jibbs

@Quadcrew6671 8 месяцев назад

Thank you that is great, would like to know, how to save the results into a sharepoint list, is there already a fitting video? Thanks very much in advance 👍👍

@jibbsautomations 8 месяцев назад

Hi Thanks for watching! I do not have a video for that, but it should be possible using the SharePoint connector actions "Get list" and "Update items". These will allow you to put your results into a list!

@reliquary1267 7 месяцев назад

Does this still hold up in the new power automate (with the AI tools)? Followed this exactly and flow fails at the first split action. Looks like no data is being composed. Thanks!

@jalalbehnam1901 7 месяцев назад

Same, i get the following error. Unable to process template language expressions in action 'String_to_body_text' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'NULL'. Even gave me an error once where it said the type was Array.

@reliquary1267 7 месяцев назад

@@jalalbehnam1901 well at least I know now that I'm not crazy! So what is the solution in this new AI environment? Really need to get this working. I'm wanting to send form data in a fixed format from a Wix site with an attachment, then parse and send data to sharepoint list

@reliquary1267 7 месяцев назад

@@jalalbehnam1901 When I look at raw input/output from the body compose, there's nothing but as if it is empty html. So "type NULL" would then make sense right?

@jibbsautomations 7 месяцев назад

Hi, thanks for posting. I have several flows running these actions and they are holding up even after the UI update. When I edit these flows, I switch back to the classic UI. I havent tried creating a new flow with these actions in the new UI yet, but I plan to do so soon.

@loafoftoast2034 7 месяцев назад

@@jalalbehnam1901 I was having this error. For me there was a "for each" loop around the Html to text with the EnterKey and first Split section sat outside this. Once i'd moved both of those within the "For each" loop as actions following the html to text, it worked.

@sujithv92 9 месяцев назад

What is the enter compose action doing? Thank you for this. Want to understand

@jibbsautomations 9 месяцев назад

Hi thank you for posting. As I understand it, the EnterKey action is to identify new lines from the email body.

@justinjohnson6113 7 месяцев назад

@@jibbsautomations The EnterKey, as used, will add a space after each new line of text. This could be a recent update. It's a great video this is extremely helpful.

@jibbsautomations Год назад

Need a use case for this flow? Check out this video! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lAPLuHWH3JM.html Need help implementing this flow? Let’s connect! www.jeremybarden.com/automation-consulting Expressions used: Split Body Text: split(body('Html_to_text'),outputs('EnterKey')) Compose: Name: last(split(outputs('Split_Body_Text')[6],': ')) (Where "6" equals the row of the output array of the value you want to extract)

@pebkaclive 6 месяцев назад

What is the purpose of the EnterKey compose action?

@pebkaclive 6 месяцев назад

@akshaykurve4055 6 месяцев назад

@@pebkacliveu got any solution?

@jibbsautomations 6 месяцев назад

Hi! As I understand it, the EnterKey action is to identify new lines from the email body.

@jibbsautomations 6 месяцев назад

@@pebkaclive If you can post in the PA community with screenshots of your flow, we can help you out over there. Thank you!

@CMWorkspace 6 месяцев назад

@@jibbsautomationsI have tried this numerous times and getting the exact same error. Were you able to help resolve this?

@sdick01 3 месяца назад

This has saved me so much time. Thank you! I'd love to learn how to trigger an email from certain text in the body. Say you have 2 sites and want to send an email to which site is listed?

@jibbsautomations 3 месяца назад

Thanks for posting. I think you can do that using a condition. If you first extract the text, so that you have dynamic content to use in your condition, that should do the trick.