Saturday, January 28, 2023
No Result
View All Result
  • Home
  • Recent
  • Business
  • Economy
  • Investing
  • Markets
  • Personal Finance
  • Retirement
  • Tech
  • Startups
  • Insurance
  • Market Research
  • Crypto
  • Home
  • Recent
  • Business
  • Economy
  • Investing
  • Markets
  • Personal Finance
  • Retirement
  • Tech
  • Startups
  • Insurance
  • Market Research
  • Crypto
No Result
View All Result
Home Technology

How to send a scheduled Microsoft Excel report email using Power Automate

Updates Finance by Updates Finance
July 11, 2022
in Technology
0
74
SHARES
1.2k
VIEWS
Share on FacebookShare on Twitter


You might also like

Best Juicer of 2023 – CNET

Best ultraportable laptops 2023: Best overall, best battery life, and more

Twitter vows to take ‘less severe actions’ against rule-breaking accounts

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.

Editorial photo on Microsoft Power Apps theme. Illustrative photo for news about The Microsoft Power Apps - a low-code development platform for building custom applications
Image: photo_gonzo/Adobe Stock

My article How to use Windows 10 Task Scheduler to run Office 365 tasks shows you how to schedule a recurring Office task using Windows Task Schedule. It’s a bit involved and requires knowledge of VB Script.

Now, thanks to Microsoft Power Automate, you can create a flow to keep up with your recurring tasks. They are quicker and easier to implement than a scheduled task that requires VB Script. In fact, you won’t need any code, because the flow creates the code internally for you. In this tutorial, I’ll show you how to use Power Automate to create a flow that sends an email with an attached Microsoft Excel workbook everyday at the same time.

SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF) (TechRepublic)

You’ll need Microsoft 365, which now includes Power Automate and OneDrive for Business. Although Microsoft Power Automate Desktop is free to Windows 10 users it comes with some restrictions:

  • You can access flows only from your desktop.
  • You can’t collaborate on desktop flows.
  • You can’t combine desktop flows with cloud flows.
  • You can’t use AI builder.
  • You can’t schedule flows.

That last one means you need Microsoft 365 to access Power Automate’s scheduling options.

How to prepare for the schedule flow

Must-read Windows coverage

Before you do anything, think through the process you want to automate. For this example, let’s suppose the boss wants to see the same Microsoft Excel sales report every afternoon. Instead of worrying about scheduling, unexpected sick days and so on, you can create a flow using Power Automate that will send that report to your boss every day.

You’ll need a Microsoft Excel file and a flow — that’s it. For the dummy Excel file, save a blank Excel .xlsx file to OneDrive for Business with the name Daily Sales Report for Boss.xlsx. It’s blank because we don’t need data; we only need a dummy file to reference in the flow. When updating this technique for your files, be sure to adapt the name and location. You could use any Microsoft 365 file for this flow as long as it’s saved to OneDrive for Business.

Now let’s move on to the flow.

How to start a scheduled flow in Power Automate

Sign into Power Automate via OneDrive or your Microsoft account. Regardless of how you sign in, start a new flow and then choose Scheduled Cloud Flow in one of two ways, as shown in Figure A.

Figure A

Choose Scheduled Cloud Flow.

Refer to Figure B to complete the initial settings. Name the flow Daily Sales Report to Boss. The Starting setting defaults to the current day, which is fine. Yours won’t match mine. Choose the time, 3:45PM, from the time dropdown. Change the Repeat Every interval to Day. After setting these items, click Create. The resulting flow will run every day at 3:45PM.

Figure B

Set the start time and recurrence for the flow.

You can edit the flow at any time by clicking the Recurrence title bar. At the bottom of this edit window, click the Advanced Options link to set time zones and other advanced options shown in Figure C. Feel free to look around a bit, so you can see what’s available. We won’t complicate the example by setting anymore recurrence options.

Figure C

The advanced options offer more control for the schedule.

Click the Recurrence bar to close the scheduling options. Now that you’ve scheduled the flow, let’s add what it does.

How to send an email in Power Automate

To move on, click New Step, shown in Figure D. Choose Microsoft 365 Outlook to the right. If you don’t use Outlook, choose the appropriate mail app, such as Mail. Doing so will display a list of possible actions. Figure E shows a few Outlook actions. Choose the Send Email action.

Figure D

Click New Step to access apps and actions.

Figure E

Choose Send Email from the list of actions.

Use the settings in the resulting action window to denote who gets the email. In this case, enter your email. You don’t want to enter your boss’ email while you’re exploring. Use Figure F as a guide to set the three required options.

Figure F

Fill in the required settings.

Then, click Show Advanced Options near the bottom so you can identify the attachment — the blank Excel file you saved to OneDrive earlier. This flow doesn’t require any dynamic options because the email is going to the same person with the same attached file every day.

Using Figure G as a guide, enter the name of the file. Next, grab the link from OneDrive for the actual file — open OneDrive, browse to the appropriate folder and open the file. Copy the URL to the Attachments Contents field. In the Reply To control, enter your email.

Figure G

Identify the attachment by file name and location on OneDrive.

When all the settings are correct, click Save. Power Automate will prompt you to test the new flow. I recommend that you do so before putting the flow into production. If the test returns no errors, check your email account. Figure H shows the email with attachment in Mail.

Figure H

The flow will send you an email with the attached Microsoft Excel file.

If the flow returns an error, check the location link of the Excel file on OneDrive for Business. Also check the email accounts to make sure they are valid accounts within your organization.

Stay tuned

Setting up this flow takes only a few minutes. If the boss makes a request to change the frequency or time, you don’t have to create a new flow and delete the existing one. Simply edit the existing flow accordingly.

This flow doesn’t consider whether you’ve updated the Excel file — it’s up to you to do so. Fortunately, there’s a flow for that, and in a future article, I’ll show you how to send a daily reminder using a Power Automate flow.



Source link

Tags: AutomateemailExcelMicrosoftpowerReportScheduledsend
Share30Tweet19
Updates Finance

Updates Finance

Recommended For You

Best Juicer of 2023 – CNET

by Updates Finance
January 28, 2023
0

In this article: I can't say for certain that juicing is the key to health and longevity. But it's worth noting that famed nutrition guru and father of...

Read more

Best ultraportable laptops 2023: Best overall, best battery life, and more

by Updates Finance
January 28, 2023
0

If portability is a top priority of yours, then investing in an ultraportable laptop is the way to go. This class of laptops are exceedingly thin, lightweight, and...

Read more

Twitter vows to take ‘less severe actions’ against rule-breaking accounts

by Updates Finance
January 28, 2023
0

Twitter is promising that it’ll take “less severe actions” when disciplining accounts that break its rules; it’ll only suspend Twitter accounts that engage in “severe or ongoing, repeat...

Read more

New York City-based Paradigm, whose tech streamlines data aggregation and patient recruitment to speed up clinical trials, launches with a $203M Series A (Maureen Farrell/New York Times)

by Updates Finance
January 28, 2023
0

Maureen Farrell / New York Times: New York City-based Paradigm, whose tech streamlines data aggregation and patient recruitment to speed up clinical trials, launches with a $203M Series...

Read more

NASA’s ‘Mega Moon Rocket’ aced first flight and is ready for crewed Artemis II launch • TechCrunch

by Updates Finance
January 27, 2023
0

The enormous Space Launch System passed its first test with flying colors, NASA’s preliminary analysis concludes, and the rocket and Orion capsule are good to go for their...

Read more
Next Post

Where Are Gas Prices the Highest?

Related News

‘Top Gun: Maverick’ Isn’t Streaming, Even as $20 Digital Sales Land Today

August 23, 2022

Fed Regulators Looking at Musk’s ‘Full Self Driving’ Tweet

January 10, 2023

A Guide to Buying Cell Phones in Bulk

August 19, 2022

Browse by Category

  • Business
  • Cryptocurrency
  • Economy
  • Insurance
  • Investing
  • Latest updates
  • Market Research
  • Markets
  • Personal Finance
  • Retirement
  • Startups
  • Technology

Get the latest Financial news on updatesfinance.com. Business news, Economy news, Investing news, Personal Finance and more.

CATEGORIES

  • Business
  • Cryptocurrency
  • Economy
  • Insurance
  • Investing
  • Latest updates
  • Market Research
  • Markets
  • Personal Finance
  • Retirement
  • Startups
  • Technology

Recent News

  • Increasing capacity, tax remission essential to capture markets vacated by China, says EEPC 
  • Best Juicer of 2023 – CNET

Copyright © 2022 - Updates Finance..

No Result
View All Result
  • Home
  • DMCA
  • Disclaimer
  • Cookie Privacy Policy
  • Privacy Policy
  • Terms and Conditions
  • Contact us

Copyright © 2022 - Updates Finance..

Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?