Turn emails into data - Flow String functions, Email with options, terminate, and more
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- In this video, you will learn about string functions, email with options, terminate action, and a bunch more. And as a bonus we do this while teaching you how to turn email text into useful data! Very fun.
Power Apps and Power Automate (flow) training at training.Power... - วิทยาศาสตร์และเทคโนโลยี
Bro, this video saved me. I've been playing with the idea of taking something out of an email for almost 3 years. It was the way you described your steps which helped me the most vs how everyone else online was giving examples. Thanks again!!!!!!!!
That is great Paul. Hope you got it all worked out. It is painful but awesome when you are done.
This is great and its NOT too much or too nerdy. Do more like this!
Thanks Tyler 😎
Your videos are a life saver for me. You really know how to explain things so I understand them. Thank you.
Glad you like them!
"I just deal with the fact that it failed and life goes on.."
Love it! Absolutely :)
Me too. Sometimes I'm just like meh, not important right now.....
😂
Thanks for sharing the thought process behind this and for reviewing how to use compose.
My pleasure!
Wow love the 'run after' section, have not yet used that feature. Thanks Shane.
ON my list :)
Can't thank you enough for this. I've had no experience with Power Automate and I'm glad I found this video which led me to finally design a flow I wanted. The advantage I had is that I could design these emails myself and then write something like Name1=xxx|Email1=yyy|etc in a very small font and then so I could easily index them. A possible problem with counting the position from "Name" is that the HTML formatting could change because the developers want to without informing end users, causing a change in index of where the name is.
By far the best lecture on data operations...thank you so much for sharing your knowledge..
So nice of you
Not nerdy at all. That's life - sometimes a bit nerdy! Keep up great explanation 👌
Thanks 😊
That was awesome, Shane. Keep the nerdy flows coming!
Will do! 🤓
Thank you, this was just what I was looking for.
You're very welcome!
Great tutorial, just started trying to get email content to populate a SharePoint List and had trouble capturing dynamic content. Not anymore after watching this, great job Shane!
Awesome Jim!
Well i have done string manipulation by extracting data from email body. However,i have used first and last function to extract the data and it works pretty great with less actions in the flow. This video was really helpful to look for another approach of string manipulation.
Cool. There are a lot of ways to do this type of stuff for sure. 😊
Shane loved this, really helped a lot. I applied it to a lot of different flows and loved the automate concept.
Thanks 😊
THANKS so much - I have been trying to figure out how to do this for ages :)
You're very welcome!
Great Video, your videos have helped me loads in powerapps over the past couple of years and I’m I’ve always almost being scared of getting into flow cause it seems hard, but your videos do help by breaking it all down and it also shows just how powerful flow can be and that actually it could be really handy so yeah, it’s actually got me more interested to look what else it can do and have a go. 👍👍
Awesome 😎
So looking forward to this one Shane...I've played around with this myself, but really keen to see your approach as mine is a bit messy!!
Hope it helps Simon
Notepad++ will make life lot easier :) but this is really a fantastic video. Very informative and full of tips and tricks. Thanks for this
Thanks 😊
This is awesome and definitely heard the thunder ⛈
Thanks. I will try better to get the weather to play nice next time. 😁
By the way, this kind of video with variables and new functions its really interesting
Thanks 😊
So much useful information. Great. Thank You!
Glad to help. 😀
Great Information, Thank you
Happy to help
Thank you so much for this knowledge!!! :)
Glad it was helpful!
Great video as usual Shane!
Yes I would be happy to see more Power Automate videos 😁😁
Keep up the good work 😊
Shane, great video - I've spent the last week looking for solutions to transform email text into data and nothing matches this!
I show you the pieces here. No one is going to have your exact solution. You will have to parse your data your way.
@@ShanesCows I meant your video was invaluable and steered me in the right direction - thanks!
Nice video Shane! Makes sense to me. I find Flow/Automate easier than PowerApps personally. Haha... guess everyone is different. (Why are cascading drop downs so difficult in PowerApps!! 🙁🙁). Tnx again Shane!
😊 Glad someone does. Flow feels like my nemesis some days.
Hi @Shane,
For long flows, why would I want to use the Terminate action instead of just ensuring that none of my other conditions are applicable, so they won’t run?
Thanks for your great videos!
Terminate let’s me set the status when it triggers. So instead of failed I could have the flow be canceled or even successful
Hey Shane, this was a super informative video! I have an issue. My flow evaluates incoming emails for the presence of a keyword, which then triggers a 'Send email with options' action. The problem is this, any reply on that email thread triggers the flow (it does other stuff before the email with options part) and the flow reads the entire thread, if a keyword is present it resends the 'email with options'. I'm really struggling to figure out how to limit the 'Send email with options' to trigger only from the latest email with a keyword, instead of triggering with every email on a thread where a keyword is present. Any ideas?
Great Video, as always. And I find your videos very helpful because you show the common pitfalls that are likely to occur. One question I have is that you did a fixed character count (7792) regarding the HTML between the identifying label and chewy, wouldn't it be better to just first strip the HTML out and then have that space fixed until the next keyword length? In my environment, I will be getting emails from who knows where (but the same label nomenclature is required or it will get diverted to a manual entry process folder) so the HTML might be different.
How would you loop through the same body if it contained more than on email address?
Not sure. I haven’t done that one.
Hi Shane, as usual, thanks for this detailed guide. I cannot use the built-in approval system also as I look after multiple tenants on Office365. I am using the send email with options and it works brilliantly using conditions and parallel branches. Do you know if it's possible to add the comment feature or is there a workaround?
Thanks again.
NOt sure. I usually do my approvals these days with just Power Apps like I show here. th-cam.com/video/49O284deOAI/w-d-xo.html
Good day Shane .. I’m new to PowerApps and your video have been a great help.. I built this App with 7 screens with buttons to Navigate , but I was looking to do a Dropdown list for Navigation .. can PowerApps do this .. Thanks for all the great videos Martin
Yes. Use the OnChange property of the Dropdown with an If and then the navigate.
Shane Young Thanks ... I will try
Hi Shane, super helpful video. I'm trying to learn by replicating your flow. Question: when I go to copy the body of my email (as you do around the 14:30 mark) my outputs say "click to download" and then it opens a tab full of unformatted text - no nice and neat red and blue or separated by rows. Do you know why it would show differently and how I would proceed in order to copy what I need to in order to go on to your next step?
HEy Sara. Sadly they changed how Output works. YOu will have to click to download and then sort out the mess. 😕
Aaahh, so that's what run after is for :)
Yup. Kind of cool. 😊
Hi Shane, I found a problem that I couldnt work around. I found that once a user triggers a flow, (and in that flow there is a "send email with options" action, he could go to his outbox and click the options in that email himself. Isnt that strange? He could potentially "approve" a purchase of an expensive item for example.
Hi, when doing the compose about the indexof, it is stating an error, expects its first parameter to be of type string. The provided value is of type Object. I copied and pasted the body of the email in the first compose, I don't know what to do. I need some help.
How do we get users to get to ask them to input their responses to specific questions as an action?
Typically with a Power Apps app
Is it possible to run specific exe file/app, if I receive email with specific text in subject?
Not that I have done but maybe with an UI flow?
Hey Shane!, I was looking through your other power automate videos, but I can't find an answer to a question I have. I am working on a flow, where I get an email from an specific email, and create a sharepoint item. I was able to create the whole flow, but I have a column "User", where the "user claims" extension, takes the destination email (me, in this case), but the problem I have, is that I have 2 destination emails (me and someone else), so, they whole flow fails. I have tried String function, but i can't make it work. Do you know how can i extract just the first email in the destination field??
Sorry I am slow. I haven't done that one before but hopefully you go it.
@@ShanesCows haha no worries... I haven't been able to make it work yet, but will keep trying until i get it right :)
Hi Shane, did you try power automate for Android, I cant launch. Thank you
I don’t have Android but I know other people do it all of the time
HI shane can you tell me how to automate the dynamic email body (every email body is unique) from excel sheet with the proper format line spaces in email sending to the email receiver
It is possible. You would use apply to each to do the dynamic content.
@@ShanesCows Its not very simple shane, I raised 20 tickets to get this solved frm microsft but no body was able to solve, im trying to power automate the emails from excel sheet where To , subject , body (multiple paragraphs) are unique in excel which are predefined and im trying to load into flow but the emails are going into inbox but not in proper format , the body of the email is not organised how it was defined in excel sheet. I hope you understand
Hi Shane where we get that notepad content
Https://training.powerapps911.com and sign up for the Curated Library. Then you can download lots of stuff. 😀
Help....probably simple ...for you, not me...
I have the same situation, email coming in that I need to track.
My flow has the following step, HTML to text, enter, and split HTML to text (which gives me multiple lines to select from by another split.
I am good with getting each line and storing / linking it store / in my excel file
but...I don't know how to combine the line, like the description field that can be up to 3 line (8, 9, 10)
example....instead capturing part of the line with Split(outputs('Split_body_text')[22],' : '))
I need to combine three lines that are only text (no split needed)
what would the compose function be???
Hi, do you happen to know how could I send a HTML Table from Flow to Powerapps??
Response action should work.
How to extract data from existing mails
You have to do exactly what you see here. Grab the email body and then string parse it. Not hard but can be very tedious.
Thank you. You need to get Chewy a sister and call her Flowy 😉
That would be cool! 🐩🐕🦺 I love it!
Nice video mate. How do I terminate my flow based on outcomes of Approvals? Without adding heaps of branches..
You would have to have conditions and then call the Terminate action
Shane Young thanks Shane. But to have conditions is to have branches right?
I used an IF statement to filter out RunStatus.
Eg. IF(equals (outcome of approval,’X’),’Cancelled’,’’) downside is if IF returns FALSE, my flow says Failed.
I want parse email body with table like below：
name age
Jack 18
Tom 20
…
key point is every email have uncertain items in every body。
so can you help me parse the data into Excel online ，thanks。