fbpx

Work automation without programming

Work automation sounds like an IT or programmer topic. It is not. Anyone – without any programming background can automate repetitive manual processes – using Power Automate (PA) – which is a part of Microsoft 365 (Office 365). Here is the video of the session I conducted on 19th Jun 2021.

1 hour 40 min – includes five live demos and Q&A

The concept is simple. There is a trigger and one or more actions. For example, when someone submits a form, PA will notice it and send automated emails, create tasks for specific people and send notifications. How long does it take to get started? Maximum two hours.

The best part is, PA works with 300+ non-Microsoft products as well. Each one has some triggers and actions. All you have to do is think of a manual process, find the product which triggers the action and look for a template.

Video Table of Contents

Downloads

Download this Zip file. It contains five workflow demos which the video demonstrates.

  1. Resources – Quick Wins and Next Steps.pdf
  2. Copy the powerplatform folder, along with the attachments subfolder to your OneDrive root folder.
  3. Five zip files – each containing one demo workflow.

How to upload demo flows

The demos are – Birthday wishes, Mail Merge, Approval, Form submission handler, Panic button.

  1. Go to Power Automate
  2. Go to My Flows – choose Import
  3. Choose one of the zip files
  4. At the bottom look at Related Resources.
  5. You may see one or more items with a link – Select during import
  6. Click on each of those links and login using your Office 365 Id.
  7. Finally, click the Import button.
Select During Import option while importing flows using zip files in Power Automate.

Excel file data

Birthdays and Mail merge data are two Excel files included. These contain fictitious email ids and data. Please add your test email ids and your data wherever necessary. For mail merge, we are using three rows which require three pdf files in the attachments folders. In case you change the file and folder names, you will need to change the settings in the Power Automate flow steps.

Configure and customize demos

Click each step of the workflow. Look at all the parameters and check if they need modification. Specifically check three things…

  1. appropriate email ids
  2. Correct folder names
  3. Team names from your environment

If this information is missing or wrong, the flows will not work. Once all parameters are set, click Save and then Test each flow.

Start learning work automation

Now that you have everything needed, start learning work automation. You can see the video and follow along using the sample files. If you have any queries, please post them as comments below this article. If you find this useful, please share it with your colleagues and friends.

2 Responses

  1. Thanks for this wonderful session….!
    Seeking your expert guidance on the below request.
    Thanks In advance…!
    We have requirement for automation request combining Outlook and Jira as below.
    Requirement: ”Automatic ticket creation in Jira once alert mail is received by searching for specific keywords in mail like specific DB Names etc”.
    But certain functions of this tool like creating a new issue in Jira based on a mail event in outlook seems to require premium costing.
    Kindly please provide your guidance/suggestions on any alternate method/functions that can be done to bypass the premium costing?

    1. Connector Premium status is decided by Microsoft (and the third-party-provider as well, I suppose). We cannot change that part.
      Having said that, explore if Jira itself provides some direct email integration – which obviates the need for using Power Automate Premium connector.

Queries | Comments | Suggestions | Wish list

%d bloggers like this: