SharePoint Document Issues

Can You Create Microsoft Forms from a SharePoint List?

Steven Parker Oct 23, 2026 869 views

Question details

The user wants to generate a form from SharePoint list data to allow team members to review, approve, or reject requests.

Can You Create Microsoft Forms from a SharePoint List?

Product: Microsoft SharePoint, Microsoft Forms, Power Apps
Device & OS: not provided
Scenario: Creating an approval workflow where users can review and action requests based on existing list data.
Observed behavior: Currently, Microsoft Forms does not support directly generating a form from an existing SharePoint list to review or update data.

Before you start

Ensure you have the appropriate permissions to create and edit Power Apps within your Microsoft 365 environment, as Microsoft Forms alone cannot process SharePoint list approvals.

Solution 1Recommended

Create an Approval Workflow Using Power Apps

Since Microsoft Forms cannot read or update SharePoint list data directly, use Power Apps to build a canvas app for your approval workflow.

Microsoft Forms is designed for initial data collection, not for pulling existing data for review. To achieve dynamic record updates, Power Apps is the recommended Microsoft 365 tool. It allows you to connect directly to your SharePoint list, display pending requests, and add interactive buttons for approval or rejection.

Open Power Apps

Navigate to the Microsoft 365 app launcher, select Power Apps, and click 'Create' to start building a new Canvas app from blank or data.

Connect the SharePoint List

Select 'SharePoint' as your data source, authenticate if necessary, and choose the specific site and list containing your request records.

Insert a Gallery Control

Add a vertical gallery to your app screen and bind it to your SharePoint list to display the items that require approval.

Add Action Buttons

Insert 'Approve' and 'Reject' buttons inside the gallery template or on a separate detail screen for each selected record.

Configure the Patch Function

In the OnSelect property of your buttons, use the Patch() function to update the approval status column of the selected record back in the SharePoint list.

Create an Approval Workflow Using Power Apps

Alternative Automation: You can also use Power Automate to send approval emails with action buttons directly when a new item is added to the SharePoint list, bypassing the need to build a visual app interface.

Free Microsoft Office alternative

Manage Your Data and Documents Effortlessly with WPS Office

While building complex SharePoint approval workflows requires advanced Power Apps skills, many teams rely on spreadsheets and standard documents for task management. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for managing your daily reports, data lists, and documentation.

1. Download WPS Office: Visit the official WPS website and download the free installer for your Windows, Mac, or Linux operating system.
2. Install the software: Run the downloaded setup file and follow the brief on-screen instructions to install WPS Office on your device.
3. Open existing files seamlessly: Launch WPS Office and open your existing Microsoft Office documents without losing any formatting or data.

Highly compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight application that runs smoothly even on older hardware.Free to use with a familiar, easy-to-navigate user interface.Built-in PDF editing tools for secure document approvals.

microsoft office alternative - wps office

Frequently Asked Questions

Can I link a Microsoft Form to a SharePoint list?

Yes, you can use Power Automate to automatically create a new SharePoint list item whenever a Microsoft Form is submitted, but the Form itself cannot read or display existing list data.

Is Power Apps free to use with SharePoint?

Power Apps is included with most Microsoft 365 Enterprise and Business plans, allowing you to create custom canvas apps connected to SharePoint lists using standard connectors without additional premium licenses.

How do I embed my Power App into a SharePoint page?

Edit your modern SharePoint page, click the '+' icon to add a new web part, select 'Power Apps', and paste your App's web link or App ID into the web part's property pane.

Document & File Issues