Microsoft Power Automate is a service that we built on top of the Microsoft Graph. It enables you to trigger macros in a text-based or visually-driven flow. You can also use Microsoft Power Automate to transform the workflow into a workflow that you can publish to an existing platform. You can automate data collection for a receipt service or conversion to an invoice.

Using Power Automate

You can use the Microsoft Power Automate REST API to connect to the Microsoft Graph services.

The Microsoft Power Automate REST API is available on the Azure services list in the left pane and managed through the Azure Management Portal.

Here’s how to connect to Microsoft Power Automate.

  • To open the Microsoft Power Automate dashboard, select Microsoft Power Automate in the left pane. Click “Get Started” in the bottom right corner. 
  • Enter a primary name for your Power Automate team and press the “Get Started” button.
  • If you’re a recurring user, you’ll be taken to a verification page and must enter your dashboard token.
  • If you’re a new user, go to this page and follow the prompts. You’ll then be sent to this page.

You can now start using the Microsoft Power Automate service. You can read more about the Microsoft Power Automate REST API on the Microsoft Azure blog.

Here’s an example of how you would use Microsoft Power Automate with the Microsoft Graph to create a receipt template.

Save the receipt, and then use the Windows Address Book API to create a new contact in your Outlook calendar. This action will automatically open the event and add the receipt to the calendar. Next, let’s go into the Microsoft Power Automate dashboard and create the workflow to take the receipt and add it to the invoice. For this, click the “Create workflow” button. Enter the date of the receipt, enter the new contact’s information, and press the “Create workflow” button. Finally, click “Create workflow,” and the service will create the workflow. You can then view the workflow in the Microsoft Flow dashboard and add other sources for the workflow to use.

Using Azure Functions

You can use Azure Functions to automate processes. These functions are simple to use and are easy to integrate with your existing Office 365 and SharePoint infrastructure.

In the Office 365/SharePoint/PowerApps app, you can use Azure Functions to execute custom PowerShell tasks and automate your SharePoint processes. You can also connect these PowerShell tasks to your Azure Functions service to automate more complex processes.

Here’s an example of using Azure Functions to connect a SharePoint pipeline to the Excel workflow task from earlier.

You can start using Azure Functions to automate SharePoint and Office 365 processes on your Azure subscription with no additional services. Once you have signed up for a subscription, you will receive an email invitation to use the services for free.

Learn RPA using the advanced UiPath platform with the Robotic Process Automation certification training course.


Microsoft Flow lets you define simple workflows to perform a specific set of tasks. This example shows you how to use Microsoft Flow to trigger the SharePoint workflow and then automate the process into an invoice. The workflow uses the Microsoft Flow REST API, Azure Functions, and the Azure Management Portal to connect the workflow to the Office 365 and SharePoint processes. Check out Simplilear's RPA course, with this course, you will become an RPA expert, leading RPA initiatives, and improving decision-making in your organization.

Our Software Development Courses Duration And Fees

Software Development Course typically range from a few weeks to several months, with fees varying based on program and institution.

Program NameDurationFees
Caltech Coding Bootcamp

Cohort Starts: 17 Jun, 2024

6 Months$ 8,000
Automation Test Engineer

Cohort Starts: 29 May, 2024

11 Months$ 1,499
Full Stack Java Developer

Cohort Starts: 4 Jun, 2024

6 Months$ 1,449
Full Stack Developer - MERN Stack

Cohort Starts: 18 Jun, 2024

6 Months$ 1,449

Get Free Certifications with free video courses

  • Introduction to Robotic Process Automation (RPA)

    Software Development

    Introduction to Robotic Process Automation (RPA)

    1 hours4.525K learners
  • Basics of Automation Anywhere

    Software Development

    Basics of Automation Anywhere

    3 hours4.63K learners

Learn from Industry Experts with free Masterclasses

  • Java FullStack: Your Gateway to a Recession-Proof Future?

    Software Development

    Java FullStack: Your Gateway to a Recession-Proof Future?

    28th May, Tuesday9:00 PM IST
  • Learn to Develop a Full-Stack E-Commerce Site: Angular, Spring Boot & MySQL

    Software Development

    Learn to Develop a Full-Stack E-Commerce Site: Angular, Spring Boot & MySQL

    25th Apr, Thursday9:00 PM IST
  • Fuel Your 2024 FSD Career Success with Simplilearn's Masters program

    Software Development

    Fuel Your 2024 FSD Career Success with Simplilearn's Masters program

    21st Feb, Wednesday9:00 PM IST