Others

How to Handle Multiple Answer Types and Attachments in SharePoint Lists

Muhammad Talha Sep 27, 2026 869 views

Question details

The user needs to create a questionnaire that can capture choice answers, open-text responses, and separate file uploads for individual questions, which standard SharePoint list columns do not natively support.

How to Handle Multiple Answer Types and Attachments in SharePoint Lists

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Creating a complex survey or questionnaire that requires users to upload specific files for specific questions alongside text and choice inputs.
Observed behavior: SharePoint lists only provide a single, global attachment property for the entire list item and do not support separate attachment fields for individual questions.

Before you start

Evaluate whether your questionnaire strictly requires data to be housed natively inside a SharePoint list, or if an integrated survey tool like Microsoft Forms can be utilized for a smoother user experience.

Solution 1Recommended

Use Microsoft Forms for Questionnaires with Attachments

Microsoft Forms is the recommended tool for complex questionnaires because it natively supports diverse answer types and individual file uploads out of the box.

Instead of forcing a SharePoint list to act like a complex survey tool, Microsoft Forms is explicitly designed for this scenario. It handles multiple question types and seamlessly stores uploaded files into designated SharePoint or OneDrive folders.

Create a New Form

Go to Microsoft Forms (forms.office.com) and click on 'New Form' to start building your questionnaire.

Add Choice and Text Questions

Click 'Add new' and select 'Choice'. You can enable the 'Other' text option to allow open-text responses alongside standard choices.

Add File Upload Questions

Click 'Add new', select the dropdown arrow for more question types, and choose 'File Upload'. You can configure the file limit, size limit, and allowed file types for each specific question.

Distribute and Collect Responses

Click 'Collect responses' to share the form link with your organization. The collected data and files will be automatically organized for you.

Use Microsoft Forms for Questionnaires with Attachments

Automated Integration: You can use Power Automate to automatically sync the responses from Microsoft Forms directly into your SharePoint list.

Solution 2

Store Attachments in a Document Library and Link to the SharePoint List

If you must use SharePoint lists, you can bypass the single-attachment limitation by storing uploaded files in a separate document library and pasting their URLs into list columns.

Free Microsoft Office alternative

Looking for a Better Way to Manage Survey Data?

Once you have collected your questionnaire data using SharePoint or Microsoft Forms, managing and analyzing the exported results is much easier with WPS Office. As a free, lightweight, and highly compatible alternative to Microsoft Office, WPS Spreadsheet provides all the robust tools you need to sort, filter, and chart your survey data.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your device.
2. Export Survey Data: In Microsoft Forms or your SharePoint List, select the option to 'Export to Excel' to download your collected responses.
3. Analyze Data: Open the exported .xlsx file using WPS Spreadsheet to securely analyze your survey responses, apply pivot tables, and generate charts.

Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your exported Forms data opens flawlessly.Lightweight design ensures fast loading times, even when handling large datasets from extensive surveys.Completely free, all-in-one suite covering Writer, Spreadsheet, Presentation, and PDF tools.Familiar user interface requires no learning curve for easy data migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I add multiple attachment columns in a SharePoint list?

SharePoint lists are designed with a single, unified attachment property for each list item. The system does not support creating custom column types specifically for file attachments, limiting you to one generic attachment repository per entry.

Where are Microsoft Forms file uploads saved?

When you add a file upload question to Microsoft Forms, a dedicated folder is automatically created in either your personal OneDrive for Business or the associated SharePoint Document Library, depending on whether the form is personal or group-owned.

Can external users upload files to Microsoft Forms?

No, the file upload question type in Microsoft Forms is currently restricted to respondents within your own organization. External or anonymous users will not be able to interact with file upload questions.

Office Quick Solutions