Automatically Approve Microsoft Forms Files in SharePoint with Power Automate
Question details
The user needs to automatically approve Microsoft Forms response workbooks and attachments in a SharePoint document library so submissions do not remain in draft after version control updates.

- Product
- Microsoft Forms, SharePoint Online, Power Automate
- Device & OS
- not provided
- Scenario
- A Microsoft Forms response workbook is stored in a SharePoint library with version control and content approval enabled. Every form submission or attachment updates the workbook and requires manual approval.
- Observed behavior
- The workbook remains in draft status after Microsoft Forms updates, and attachments upload successfully but still trigger approval errors.
Confirm that you have permission to manage the SharePoint library and can create automated flows in Power Automate. Check the document library version control and content approval settings that are causing the draft state.
Create a Power Automate flow to approve SharePoint library items automatically
Use this when a Microsoft Forms response workbook or attachment is stuck in draft because the SharePoint library requires content approval on every update.
Power Automate can run when a Forms response updates the Excel file or when a new attachment is uploaded, then set the SharePoint content approval status to Approved. The exact trigger and conditions depend on whether the file is updated in place, replaced, or uploaded as an attachment.
Sign in to the Power Automate portal, select Create, then choose Automated cloud flow.
Search for SharePoint, select When an item or file is modified, and set the SharePoint site and document library that receives Forms responses.
Add a new step, search for SharePoint, select Set content approval status, choose the current item, and set the status to Approved.
If Forms attachments are uploaded as separate files, add a parallel branch or a separate flow using the When a file is created trigger so each attachment is automatically approved after upload completes.
Save the flow, submit a new Forms response, and confirm that the workbook and attachments no longer remain in draft.

Use WPS Office as a Free Microsoft Office Alternative for SharePoint and Forms Workbooks
WPS Office does not control SharePoint or Power Automate approval workflows, but it is a free, lightweight Office alternative that opens and edits the Microsoft Forms response workbook in .xlsx format. You can review, filter, and update response data with a familiar interface while migrating between Microsoft 365 documents easily.

Frequently Asked Questions
Why does my Microsoft Forms workbook remain in draft in SharePoint?
It usually means the document library has content approval or version control enabled. Each time Microsoft Forms updates the workbook or an attachment is added, SharePoint creates a new draft item that must be approved before it becomes the published version.
Can SharePoint automatically approve Microsoft Forms files without Power Automate?
There is no one-click SharePoint setting to auto-approve every new or modified item. You can either turn off content approval in the library, or use Power Automate with the Set content approval status action to approve files automatically.
Why do Microsoft Forms attachments upload successfully but still show approval errors?
Each attached file is treated as a separate SharePoint library item. If the library requires approval, the attachment inherits that requirement and remains in draft until you approve it or a flow approves it automatically.
Does WPS Office fix SharePoint approval workflows?
No. WPS Office can open and edit the workbook after it is available, but the SharePoint content approval workflow is controlled by SharePoint and Power Automate.
What permissions are required to create the Power Automate approval flow?
You need access to Power Automate, permission to edit the SharePoint site and library, and rights to manage content approval status for the documents or items in the affected library.




