Click “New Flow” at the top, or switch to the Flows tab and click “New Flow.” Give the flow a name and then click create.

If the boss wants to review a Microsoft Excel report every day at the same time, don't worry: You can use a Power Automate flow to automatically send that report on time.

Figure O The flow sent two emails to my Microsoft Outlook Inbox while testing. Creating a Power Automate flow is easy considering what you gain in return — freedom from repetitive tasks!

Access Power Automate directly from the ‘Automate’ tab within Excel. To streamline the process, opt for a pre-existing template specifically designed for sending emails based on selected rows.

Power Automate is also getting a new feature called AI flows, which are now available as part of an early access program.