I have a Microsoft Form that works fine, I can click "View Responses" and it loads a webpage showing the responses in an Excel-style webpage.
I want to alter the id/unique id column on that view/page so that instead of reading 1, 2, 3 etc it reads REFCODE1, REFCODE 2, REFCODE3 etc. (It doesn't appear to be possible to customise that column in Forms.)
How do I go about doing that?
Is the "View Responses" page of data actually accessible in Power Automate?
Thanks.
@Pete_81 You can't edit the ID column. However on the Responses page of your form, click the Open results in Excel button.
Once you press that button the Excel file will be created in OneDrive (personal form) or SharePoint (group form).
You'll need to add a column to the table to store your custom ID. You will need the default ID column so you can use it as the key value in the Update a Row action.
Make sure you are editing your flow in the Classic Designer. The New Designer is still pretty buggy especially when it comes to the MS Form trigger and action.
You might find these YT Tutorials helpful:
How to Get Microsoft Form File Uploads Attached to an Email 📧
In this Microsoft Power Automate tutorial, I’ll show you how to get your Microsoft Form responses into SharePoint. I’ll cover how to build a Microsoft form with conditional fields by using branching. You’ll learn how to format your multiple choice responses for a SharePoint multi-choice column as well as converting it to text. I’ll also show you how to take a text response and convert it to a number with a switch action and with an expression. After adding the response to SharePoint, we’ll send the user an email confirmation with all the details of their form submission.
I also cover the following in the tutorial above:
✅ Two types of MS Forms
✅ Where Microsoft Personal (OneDrive) Form File Uploads are Saved
✅ Where Microsoft Group Form File Uploads are Saved
✅ How to Add a File Upload Question to an MS Form
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form Response
✅ How to Get the Dynamic Content Microsoft Form File Upload Content
✅ How to handle Single and Multiple Microsoft Form File Uploads
✅ How to use a Scope action to Organize and Group Your Flow Actions
✅ How to Get the File Content from an MS Form File Upload
✅ How to Collect All Files Uploaded to a MS Form and Attach to an Email
✅ How to Handle MS Form Response When a File Isn’t Uploaded
✅ How to Create an Email Key
✅ How to Send an Email to a Specific Recipient Based on Form Selection
✅ How to Create a Dynamic Output Based on Form Selection
--
How to Get Microsoft Form File Uploads Attached to an Email 📧
In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.
IN THIS VIDEO:
✅ Two types of MS Forms
✅ Where Microsoft Personal (OneDrive) Form File Uploads are Saved
✅ Where Microsoft Group Form File Uploads are Saved
✅ How to Add a File Upload Question to an MS Form
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form Response
✅ How to Get the Dynamic Content Microsoft Form File Upload Content
✅ How to handle Single and Multiple Microsoft Form File Uploads
✅ How to use a Scope action to Organize and Group Your Flow Actions
✅ How to Get the File Content from an MS Form File Upload
✅ How to Collect All Files Uploaded to a MS Form and Attach to an Email
✅ How to Handle MS Form Response When a File Isn’t Uploaded
✅ How to Create an Email Key
✅ How to Send an Email to a Specific Recipient Based on Form Selection
✅ How to Create a Dynamic Output Based on Form Selection
Hope this helps!
I do not think it possible to do what you want to in the FORMS.
You could look at doing this via a SharePoint List see the following that might explain what I mean.
https://www.youtube.com/watch?v=V4Nli38Uh5o
I have not done any of the above but other may be able to help better.
Regards,
Andrew
That column cannot be edited. It is the primary key of the list. If you alter it, the get response details action will not work. If you need the prefix to be "REFCODE" for an e-mail or something else, just use the value as it is returned and manually add the prefix.
You access the details of the response as follows:
There is no way to access all of the responses through Power Automate.
Although, I suppose if you really needed to get all of the prior responses when a new response is submitted, you could set a variable of the current response value as an Integer. You can then add a Do until action and set it to where the variable is equal to 1.
Then in Do until use the Get response action details and use the variable for the Response Id value. Once it gets the response, do whatever is needed then increment by negative 1. I haven't tested this, but it would look something like this:
This would assume that you do not delete any responses from your form. If you do, you will need to build in error checking.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2