How to make Approval Form in PowerApps-Part I

Learn how to easily make Approval Form in PowerApps in just few simple steps. Subscribe to our newsletter for more SharePoint tips.

Hello everyone !! We are back with another edition of SharePoint Tips. This is going to be a blog series. So, stay tuned! In the first part, we will show you how to make a mobile app in PowerApps that connects to both Flow and SharePoint with an aim to have an easy items submission and approval process.

Let's get started.

  • To begin with we will be using a list named as Approval list with some simple fields. It is in this same list that users will be submitting the items and the same items will be approved.

Capture 102

  • In addition, we have also created an app from scratch with simple header and two buttons that don't work.

Capture 101

To start, you need to connect the app to the approval list. To achieve the same:

  • Go to view tab Data Source
  • Add a new Data Source
  • Click new connection
  • Once you do that scroll down and find SharePoint
  • Choose Connect directly

Capture 103

Capture 104

  • While that loads, grab the URL for the sub site that the list resides on and paste it as shown in the screenshot below and Click Go.
  • Capture 105
  • Now, you can easily choose the desired list.

Capture 107

  • Once that loads, you will be able to use the data anywhere in the application. Insert a form to use that data.

Capture 108

  • Connect the form to the list you just made.
Capture 109
  • Once connected, it will add all the fields in the form.You can edit the fields as per your requirements.
  • Test it to see that the two buttons Clear and Submit actually don't work.
  • To ensure that the app works, you need to initiate the form at some point in the application.
  • Type in ResetForm(Form1); NewForm(Form1) to make the clear button completely functional.

Capture 110

  • Similarly, to make the submit button function you need to type SubmitForm(Form1);NewForm(Form1).

Capture 111

  • Put some test data and choose an approver. The clear button and submit should work fine.

Capture 112

  • Once you submit the test data, go to the list and you can see the right data and approver.

Capture 113

That's all for today.

For the next part, we will be using a flow to have this data send an e-mail to the approver. The concerned approver will either approve or deny the data in the e-mail and that will have an update in this list.

Table of contents

Read more blogs

See all

SharePoint & Microsoft 365 (Product Tips & How-Tos)

A Basic Guide to Project Sites in SharePoint Online

SharePoint project sites are a powerful collaboration tool. Learn all about building and using a SharePoint project site on our blog!

Read more

SharePoint & Microsoft 365 (Product Tips & How-Tos)

New URL filter improvements in Power BI

Microsoft Power BI offers new filtering capabilities. You can define more complex report-level filters directly in report URL as query string parameters.

Read more

SharePoint & Microsoft 365 (Product Tips & How-Tos)

How To Create a Multilingual SharePoint Site

Learn how SharePoint online multilingual sites are created and how to enable the multilingual feature in your SharePoint communication site.

Read more

Less time on contracts, complete control over them.

Automate contract tracking and renewals, connect every agreement to its vendors, invoices, and projects, and get full visibility with enterprise-grade security built in.

Our contract process didn't fit neatly into the rigid workflows offered by many vendors.

Dock 365 was the last vendor I looked at, but it quickly became clear it was the right fit

Jennifer McGaffey

Legal Operations Manager, Short Elliott Hendrickson