Power Automate Tutorial: Read from Excel and Send Email

Подписаться 222 тыс.

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

50% 1

In this video Jonathon shows how to use Power Automate to read from an Excel file online and sends an email for each row based on a specific condition. Notice how he utilizes the Float expression within the condition to pass through a decimal value within the flow (this is especially useful when working with currency fields).
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Jonathon30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks #JonathonSilva
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

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

3 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@lpdowdell Год назад

Super amazing explanation!

@PragmaticWorks Год назад

Glad it was helpful!

@carloscantu75 Год назад

Great explanation, thank you for sharing.

@PragmaticWorks Год назад

Thanks for watching!

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

You saved my day, thx.

@Dmoneyfit Год назад

Flow failed at the condition step: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

@kukudanzi4236 Год назад

Hi i need your help with a flow. i have a choice column for different organizations and each org has 4-5 email ids. so when i select a particular org name.( i have created list of mail ids in excel under each org column). I want a flow where it reads the org name from list and excel send the mail accordingly

@vv9022 Год назад

Hi Jonathan, thanks for this video. This is exactly what I am trying to do, with a table (a bit complicated table with customers' private information) in it and with a logo (flyer kind of look) email, so it is structured like a pdf but want merge fields in the email to personalise. I am keen to know if power automate is secure for this purpose if we are sending it to 100 customers and don't want to anyone's data compromised. Is power automate a good solution for that or should I use something else? TIA

@KiranKumar-ec6qf 9 месяцев назад

Hi Jonathan, thank you for the video I able use it. How do I create a flow for which can trigger and email based on the two values in a row condition with AND. Send and email from out look. If possible please help. Thank you very much. I tried from my side it says no errors or warnings and Test says success but no email triggers. I have been working on this requirement for the past 4 months.

@HananElsharif-wz4ci 21 день назад

Hi there. This is the type of thing that I was looking for. Will this work if I have data populated from MS forms into an excel spreadsheet. What I want to do is add a column in the spreadsheet and type 'complete' in a row when we have actioned what has been asked of us. I want powerautomate to send an email to the email in that row to say that the task has been completed.

@anuradhashankaran1494 Год назад

Amazing explanation! For decimal values you have used Float expression. In case I want to send emails based on due date could you let me know what's the expression to be used? Thanks!

@Jonathon_Silva Год назад

You could add the date in the conditional check if you want. It could be something like DueDate (dynamic content) equals 'your choice of date'. You can also have that choice of date out into the future so send if the due date is a week from today - that would be using addDays(utcNow(), 7)

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

I love this! One question.... How would I look at specific dates? I want to use this for our current contracts with vendors and get a notification on the date of renewal. So instead of your "Invoice Amount" it would be "Renewal Date" but will it be able to read a date correctly?

@FluffyGrl 9 дней назад

Is there a way to make this function as an automatic cloud flow rather than having to manually trigger it? I have a yes/no dropdown column and would love to send the email when that is marked yes rather than mark yes, then go into Power Automate to run the flow.

@FernandoDelRio-is2sz Месяц назад

really nice explanation, it helped me to create mine with string condition instead of number. string(items('Apply_to_Each')?['Start communication']) One question, is email restricted to 256 items? When I run test the max number of items shown was 256 and my table has at least 312 rows.

@lavanyashri7401 Год назад

I have a file attached in email how to save it to SharePoint and apply a sensitivity label 🏷 using power automate

@Neill947 Год назад

Is there a way to do this without using the one drive?

@ounmuhammad2974 Год назад

I had workflows running in Power Automate, I am sending out an email based on data contents in an excel file. I made changes (added 3 new columns) in my excel file but those changes are not appearing in email. Can you help me with that?

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

Very Nice... But I have a peculiar requirement... It goes like, I send a message to a teams channel and, that message to be evaluated on an excel file on one drive and return back it's corresponding value back on teams channel... How to achieve this.!?

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

Is it possible to create a flow based on a data set being added from a cell with validation in? We are looking to have a new email sent, everytime a row is completed in a table and the final entry added?

@cendyfauzan1481 Год назад

what if i want to send email with attachments?

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

Hi there. How would build a power automate to send an email to people in the excel with a pdf attachment

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

Am struggling with adding table name in "List rows present in table" step. what is referring table. i don't find any recommendation in the drop down even.

@KeshavRajGhimire-fy2dg 3 месяца назад

try turning off the new designer look in the top right.

@stephenwimsey1004 Год назад

Hey, I'm hoping someone an help as i'm at a lost. I've created this flow identically, with one that ive used a dynaic in the condition to search for a yes value, rather than a float, and i'm getting the following error: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each_2' referenced by 'inputs' in action 'Send_an_email_(V2)' are not defined in the template.'.'. Any clues please?

@jeffinvests7729 Год назад

hi, how do i temporary store the result in an array then only email as i do not want to receive each result with an email. Thanks!

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

I have been trying to find that out also.

@antarabhattacharjee3294 Год назад

can I send email to a gmail id through Power Automate

@marcos.2373 Год назад

thanks good explanation. But how could I do to send emails every time a row is fullfilled, without taking all the previous rows into the flow? thank you very much if you'll reply!!

@Jonathon_Silva Год назад

Unfortunately, Power Automate does not have a trigger that monitors an excel workbook for a new row.

@marcos.2373 Год назад

Hi Jonathan, got it, thanks for replying. I solved this by myself today and I'm sharing here the solution, maybe it'll be helpful for someone: you can add a column on the excel table with a yes or no to indicate if an email for that row is already sent, thus, you can add another condition inside the flow "take only rows with a NO" to send your final email. Obviously this is not a trigger by itself but I guess you can plan the input hour by hour