How to Display Microsoft Forms Attachments Directly in SharePoint Lists
Question details
Users want to display file attachments submitted via Microsoft Forms as clickable links directly within the main SharePoint list view, rather than having to open each list item individually.
- Product
- SharePoint, Power Automate, Microsoft Forms
- Device & OS
- not provided
- Scenario
- Automating the transfer of Microsoft Forms responses and attached files to a SharePoint list using Power Automate.
- Observed behavior
- Attachments transferred to SharePoint list items do not appear as clickable icons or links in the default list view grid, requiring users to click into the item details to access the files.
Ensure you have owner or edit permissions for both the target SharePoint list and the Power Automate environment. Verify that your Microsoft Form is actively collecting file uploads before building the automation flow.
Use a Rich Text Column and Generate HTML Links via Power Automate
Create a multiple-line text column with enhanced rich text in your SharePoint list, and use Power Automate to parse the Forms attachments into clickable HTML hyperlinks.
By default, SharePoint list views do not render attachment icons as clickable links directly in the column grid. To bypass this limitation, you can extract the uploaded file's URL and filename from the Forms response, construct standard HTML anchor tags, and push them into a specially configured rich text column.
Navigate to your SharePoint list, click 'Add column', and select 'Multiple lines of text'. Name the column 'Attachment Links', click on 'More options', and toggle on 'Use enhanced rich text (Rich text with pictures, tables, and hyperlinks)'.
In Power Automate, after the 'Get response details' action, add a 'Parse JSON' action. Use the dynamic content of the Forms file upload question as the input to extract the array of file names and URLs.
Use an 'Apply to each' loop or a 'Select' action to iterate through the parsed files. Construct an HTML string for each file in this format: <a href='@{item()?["link"]}'>@{item()?["name"]}</a><br>.
In your 'Create item' or 'Update item' SharePoint action, map the dynamically generated HTML string variable to the newly created 'Attachment Links' column and save your flow.
Manage Your Downloaded Documents Effectively with WPS Office
While you use SharePoint and Power Automate to route and organize your files, you need a robust, reliable suite to view and edit those document attachments. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office for all your document creation and editing needs.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free all-in-one suite and install it on your PC or Mac.
- 2. Open Your SharePoint Attachments: Click the generated attachment links in your SharePoint list to download the files, then double-click them to open instantly in WPS Office.
- 3. Edit and Save Seamlessly: Make any necessary edits and save your files in their native Microsoft formats, ensuring complete compatibility when sharing with colleagues.
Frequently Asked Questions
Why do my Microsoft Forms attachments appear as plain text code instead of clickable links in SharePoint?
This happens when the SharePoint column mapped in Power Automate is set to standard text. You must use a 'Multiple lines of text' column and specifically enable 'Enhanced rich text' in the column settings so SharePoint knows to render the HTML tags as actual links.
Where are the files uploaded via Microsoft Forms physically stored?
If the Form was created in a personal Microsoft account or directly in OneDrive, attachments are saved to a folder in the creator's OneDrive. If it is a Group Form, the attachments are stored in the default SharePoint Document Library associated with that Microsoft 365 Group.
Can I display the original file name as the clickable text?
Yes. When you parse the JSON output from the Forms attachment in Power Automate, it provides a 'name' property alongside the 'link' property. You can place the 'name' dynamic content between the HTML anchor tags (<a href='link'>name</a>) to display the original file name.
Does this method work if a user uploads multiple files to a single question?
Yes. However, because multiple files are returned as an array, you must use an 'Apply to each' loop or a 'Select' action followed by a 'Join' action in Power Automate to concatenate all the HTML strings together before passing the final combined string to the SharePoint list item.
