Others

Use a SharePoint List as a Request and Approval Form

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Set up a SharePoint list where users can submit multiple content requests for approval before they are added to a master list.

Use a SharePoint List as a Request and Approval Form
Product
Microsoft SharePoint and Power Automate
Device & OS
not provided
Scenario
Users need to submit several content requests at once and have them reviewed before they appear in a master SharePoint list.
Observed behavior
A separate request list collects submissions, and approved requests are added to the master list.
Before you start

Identify the master list columns and the person or group responsible for approvals. Confirm that you can create a SharePoint list and a Power Automate flow with access to both lists.

Solution 1Recommended

Create a Request List and an Approval Flow

Use a separate list to collect requests and automatically add approved items to the master list.

1
Create the request list

In SharePoint, select New > List and create a request list. Add columns for the information reviewers need, using columns that can be mapped to the master list.

2
Enter multiple requests

Open the request list and select Edit in grid view to enter multiple rows. Each row is a separate list item.

3
Start an automated flow

In Power Automate, select Create > Automated cloud flow. Choose the SharePoint trigger When an item is created, then select the site and request list.

4
Add the approval

Add the Approvals action Start and wait for an approval. Choose an approval type, assign the reviewer, and include request details from the trigger.

5
Add approved items

Add a Condition for the approval outcome. In the approved branch, add the SharePoint Create item action, select the master list, and map its required columns to the request fields.

6
Test the flow

Save the flow, add a test item to the request list, and approve it. Check the master list and the flow run history to confirm that the item was created.

Create a Request List and an Approval Flow
Approvals are per item: The flow runs for each newly created request item, including items entered in grid view. Approving a batch as one submission requires a different workflow design.
Free Microsoft Office alternative

Prepare Content Request Tables in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility. Prepare request tables in WPS Spreadsheets and move existing Office files into your workflow with ease. SharePoint and Power Automate are still needed for the approval workflow.

Organize multiple content requests in a spreadsheet before submission.Open and edit Microsoft Excel XLSX files for easier migration.Use a familiar spreadsheet interface to work with rows and columns.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Can users submit several requests at once?

Yes. Open the request list and select Edit in grid view to enter multiple rows. A flow triggered when an item is created will run separately for each new row.

How do I add only approved requests to the master list?

In Power Automate, place a Condition after Start and wait for an approval. Add the SharePoint Create item action only in the branch for an approved outcome.

Does SharePoint content approval move items to another list?

No. Content approval changes the approval status of an item in the same list. Use a Power Automate flow if approved requests need to be created in a separate master list.

Where can I enable content approval?

Open the list and go to Settings > List settings > Versioning settings. Set Require content approval for submitted items to Yes and save.