Others

Create SharePoint List Items with Dynamic Content Types from Microsoft Forms

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to automatically generate SharePoint list items from Microsoft Forms responses, assigning different content types and specific follow-up metadata fields depending on the user's input.

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Collecting data via Microsoft Forms and mapping it to a single SharePoint list that utilizes multiple distinct content types.
Observed behavior: Microsoft Forms does not have a native, direct integration to assign dynamic content types in SharePoint, requiring an intermediary workflow solution to handle conditional routing.

Before you start

Ensure you have Edit permissions on the target SharePoint site to configure list content types, and an active Microsoft Power Automate license to build cloud flows.

Solution 1Recommended

Use Power Automate to Route Form Responses Dynamically

By creating a Power Automate flow, you can inspect the incoming form response and use conditional branching to create a SharePoint item with the correct content type.

Since SharePoint cannot natively parse a form submission into different content types, Power Automate serves as the bridge. You can read the specific answer that determines the category, and route the data accordingly.

Set up the Form trigger

Log into Power Automate, click Create, and select 'Automated cloud flow'. Choose the trigger 'When a new response is submitted' and select your specific Microsoft Form from the dropdown menu.

Retrieve the response details

Add a new action called 'Get response details'. Select your Form ID again, and in the Response Id field, select the 'Response Id' dynamic content provided by the trigger.

Add a Switch control

Click 'New step' and search for the 'Switch' control. In the 'On' field, select the specific form question that dictates which content type should be used. Create a 'Case' branch for each possible answer.

Create the SharePoint list item

Inside each Case branch, add the 'Create item' SharePoint action. Select your Site Address and List Name. The action will reveal a 'Content Type' dropdown; select the appropriate type for that branch, then map the form responses to the corresponding SharePoint fields.

Complex Branching: If your form contains highly complex branching or dozens of content types, the flow can become difficult to manage. For advanced structural advice, consider consulting the Microsoft Power Platform Community.

Free Microsoft Office alternative

Discover WPS Office for Streamlined Data Management

While SharePoint and Power Automate are required for complex enterprise list mapping, WPS Office provides a highly compatible, lightweight alternative for everyday document handling and spreadsheet data collection.

1. Download the software: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded installer file and follow the quick on-screen setup instructions.
3. Start organizing data: Open WPS Spreadsheets to manage your lists locally, or use WPS Form to start gathering custom data immediately.

100% compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsIncludes WPS Form to easily collect data and instantly export it into comprehensive spreadsheetsLightweight software suite that consumes fewer system resources and runs smoothly on PC and MacFamiliar user interface ensuring a seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I map Microsoft Forms to SharePoint content types without Power Automate?

No, Microsoft Forms does not feature native data routing to distinct SharePoint content types. Power Automate or a similar third-party integration tool is required to evaluate the response and create the specific item type.

Why aren't my SharePoint fields showing up in Power Automate?

When using the 'Create item' action in Power Automate, custom fields will only appear after you have selected the specific Content Type from the dropdown. Ensure your content types are properly published and attached to the target SharePoint list.

How do I handle mandatory fields for different content types?

Because each 'Case' branch in your Power Automate Switch control uses a separate 'Create item' action, you only need to populate the mandatory fields specific to the content type selected within that specific branch.

Where can I get help for advanced Power Automate logic?

If you are dealing with extensive conditional loops and dynamic expressions, the best place to request specialized assistance is the official Microsoft Power Platform Community forums.

Office Quick Solutions