This is excellent. I retire in 10 days so have a dozen people wanting to do something like this before I'm gone. Haven't worked with PowerAutomate at all until this weekend. My end-users will be very pleased!
This was perfecto! The absolute best explanation on RU-vid or anywhere else! I was able to get my flow setup this morning and watched my emails populating my Excel workbook! Now my plumbing business has automated email data input. These MS tools are fantastic!
Really useful video. I am glad that you didn't put recommended videos at the end. I saw someone else's video and I couldn't see clearly the last steps because of that.
Olá, não sei como expressar isso, mas você simplesmente me salvou. Sua solução simples, rárpida, eficaz. Já estava desistindo, após muitos vídeos assistidos, perguntas em fóruns e grupos. Novamente, muiiiiiiiiiiiiiiiiito obrigado.
How did you get the little blue "fx" (function choice icon) to show in the right hand corner of box and how did you get the list of functions to show "inline". My dynamic choices show in the lower right part of the screen in a pop out box.
Hi Go to Powerautomate Settings (righ hand corner left just before the ? (question mark) Click View All Power Automate settings Set Experimental Features > On Thanks
@@abm4975 Thank you. Total beginner trying to learn on the fly. I'm having difficulty with the following: My ultimate goal for this portion is to create an Outlook calendar event from data in an Excel table. I have 2 separate cells, one for date and one for time. I am able to get the date with: 👍formatDateTime(addDays('1899-12-30', int(items('create_a_calendar_event')?['MIGRATION_DATE'])), 'yyyy-MM-dd')👍success. I am unable to get the time cell extraction to work. I'm currently using: 🧠formatDateTime(utcNow(items('create_a_calendar_event')?['MIGRATION_TIME']), 'HH:mm')🧠 fail with error: 👁InvalidTemplate. Unable to process template language expressions in action 'convert_time_to_number' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '0.65625' was not valid. The datetime string must match ISO 8601 format.'.👁 Thank you for your time.
Hello, this was very helpful in finding variables with fixed characters that never change, but I'm running into an issue where description/comments cause different numbered indexes depending on how many lines that variable is. So I'm wondering if there is a way you can substring() and instead of taking a certain amount of characters, you instead take the value until the next carriage return or something. Or perhaps there is a convulted way of doing this with multiple expression.
Hi Nathan Thanks for the support and question. Declare a compose action and press enter key. Use this compose action output value to substitute the split() expression of your text as separator. This will result in an array of values.
Hi, Thank you for a good video! I have a question. how do I do if one of my "inputs" turns into 2 rows? I have a "message" option and I want the whole message into one string of text but it gets separated into multiple rows depending on how long the message is. Do you have any tips for that?
Thank you so much for your wonderful video. I receive emails every day with a URL linking to a CSV or EXCEL file. Is there some way to automatically save the CSV or the EXCEL file to Sharepoint please.
Hello.. Thanks for the Video.. I have a question as well.. I am creating a flow. Where I need to get the details of existing emails. Not When a new email arrives.. Do we have a trigger for that?
Hi Trigger is something when an event happens such as create, modify or delete. For getting the email details use the action step called Get Email (v2) if you using the outlook connector. Thanks
Hello I have a question what if I want it to separate each text, as I am looking for a particular string of text in an email and it might wrap it with the rest of the body. Like I want each text to be represented line by line?
Hi When you use the split() expression it converts into an array. Using the index of the array you can get each lines. If you still need help post a sample text of the email and the key word you are looking for. Also how you want the output to? I will have a look. Thanks
@@abm4975 for example “please provide this illustration, when these policies are available for premium offset” this is reading as one line and I would like to differentiate each word on different lines so I can recognize certain words that’s start with P for example and ends in N. I have set up a condition at the end of my flow that already does this, but if the words are together on one line, power automate won’t pick it up. I appreciate all your help!
Thanks for your quick reply. Try use the below expression. split('please provide this illustration, when these policies are available for premium offset', ' ') This will output as an array. Then add an apply to each loop action step. Map the split() output from the previous actions step. Then inside the loop add a compose action step and add another expression called item(). This will give you each words from that sentence. Thanks
GREAT VIDEO. I am wanting to extract the last word of a line within the text. currently I am using last(split(outputs('Converted_Data')[6],': ')) but this displays the entire line of text when i only want the last word in that line
@@abm4975 the data is: " * Location: THURS Morning - Prestart 6:30AM - At: - Sandercock Park - Gold", " Coast Hwy at Paradise Ave, Mermaid Beach (320) (3D Job) (F/Move 10AM) (", " Ammar), QLD", I want to extract the last piece of text QLD, but this value can change.
Hi @dannyrene Thanks for your query. Please see my channel about section. Scroll down and see business enquiries. Click and find my email address. You can send me an email or connect me via teams. Thanks
I cant see the array output from the first split. I shows just one line with all the information. I have compose with the "enterKey" then split with the body html to text followed by the delimiter. Also, I noticed the it is bringing the whole email. It brings the subject and the body of the email.
Hi Is that two different emails. Then you need two different flows as trigger referring to those emails. Store the body in OneDrive or SharePoint. Once you received both then you can compare the body. You need three flows to achieve this. Thanks
Hello there thanks a lot! is it possible get the text between words? For example I just want the word DOG to be the output result from de following input 'CuteAnimal[DOG]'.
Hi sir, you explained very well. I understand how to pull the text from email boday to power automate But i have one question.? Can you please let me know how can we write the outputs from power automate to excel..?
Sir i usually get the reports to my email on daily basis. At the month end I will be copying the data manually from email to excel and consolidating and doing the required calculations. Can we do the above requirement using power automate..? Your suggestions will be help us to improve our knowledge on Microsoft tools and save lot of time for me
Hi Karthik Could you please post your issue in Power Automate community and tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Thanks for the explanation and really informative. I have a quick question, What If I want to opt-out entire row in email body. Example in this case would be, EE Count: 420 and Opp #: 486912
What if I have a whole line as a single array ? Like i have chabged my mail to array but it somehow chabged into 1 ARRAY. Can you please tell me how can I fetch values? Many thanks
Hi dear, thank you for sharing such a useful videos. I am looking for power automate flow in which I want to filter customer email and send the email with multiple attachments dynamically!!
Great explanation and it works with those fixed incoming emails. What about if the emails are not fixed but have different formats, however works like Short Description: Description: Sender: and Callback Number: are in different lines. What expression can you use to extract this data without knowing in what line they will be?
There is an online form that is sending me emails like that, most of the time the value that I need is not in the same row, this value always is 8 characters long and has a "reference # " next to it. What I did is after the "html to text" I put a "find text position" where it will search for "reference # ", then a new step "substring" where the starting position is the output from the previous step and the length is 8 characters. After that you can search for a video explaining how to move that data to an excel, pdf, etc. Maybe @abm can make a video with this explanation.
@@abm4975 what I am still trying to do is to save this email to one drive, just to let you know, I don't have any of the premium tools. Maybe this is not important if you come up with a solution/video, I exactly don't remember, but the error is something about what I am trying to save/export is larger than the length of the original text.
Exactly what I need to process some emails, the trouble is our exchange is on prem so the connection to the mailbox doesn't work. Tried using Power Automate Desktop but most of the operations available online aren't in the desktop version
@@abm4975 Thanks, managed to get it part working by forwarding to Gmail and doing it from there. Now having issues getting the specific data I need from the output (eg I need the data on the line after "01", sometimes there are a few instances of "01" in the email but the data I want is always on the same line after the compose).
I am having trouble with I believe the delimiter. No matter what I try, the split body text comes out on the same line. For the life of me I can’t figure out why? It’s like it isn’t seeing the enter as a delimiter? It I put other characters in besides enter it delimits using that character. So confused!
@@abm4975 let's say there's an email with subject "today is monday email" and i want to get the monday and save it to a variable. The "monday" in the subject changes. It could be Tuesday and etc. How can i get the dynamic text and saved it in a variable? Apologies im new to powerautomate :)
Hi Edward If all the subjects having starting has 'today is' or after 'two words' then its possible. Use the below expression split('today is monday emal', ' ')[2] Above substitute the text with subject text dynamic mapping field. Thanks
Hi Danil Are you looking to get the email content and store in a local file? Do you want to amend or append the file if you receive more emails? Please explain a bit more about your requirement. Thanks
Hi Video mainly focus on how to extract the values. To add the values in an Excel sheet, Add the action step called Add a row into a table then map the values. Thanks
With the extracted text from the mail body, how can we create a folder in share point with this extracted text name? It will be helpful if anyone helps me