This article demonstrates how to create an approval process in Power Automate, using the example of a vacation approval workflow.

How the completed process will work

The applicant fills in a Microsoft Forms form, specifying the desired vacation dates.

The approver either approves or rejects the vacation request.

If approved, the vacation is recorded in Excel. Regardless of approval or rejection, the applicant receives an email with the result.

How to do it?

First, create a form to input vacation details and share it with users:

Then, prepare an Excel file, insert a table into it, and place it on SharePoint, OneDrive, etc.:

In Power Automate, select this template that works with Forms, Excel, and email:

Then, choose the form to work with:

Select who approves and what information from the form they will receive:

In the conditional branches, specify which Excel file and which columns the data should be saved to. The rest will be configured automatically.

You can fine-tune many other things, but the Flow will already be functional as is. To launch it, simply fill in and submit the form.