How to Create a Form with Unique IDs and Receipts in Microsoft 365
Question details
The user wants to build a workplace form that issues a unique submission ID and a downloadable receipt to respondents upon completion.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Collecting workplace information and automatically providing customized confirmation receipts to each respondent.
- Observed behavior
- Microsoft Forms alone cannot generate unique IDs. Creating unique IDs and automated receipts requires SharePoint and Power Automate, which are unavailable in the Microsoft 365 Family plan.
Verify your Microsoft 365 subscription tier. You will need a Business or Enterprise license to access SharePoint lists and the full Power Automate features required for generating unique IDs.
Use SharePoint and Power Automate to Generate Unique IDs
Create an automated workflow that logs form responses into a SharePoint list to generate an ID, then emails a receipt to the respondent.
Microsoft Forms does not natively assign unique receipt IDs to submissions. To achieve this, you must pass the form data into a SharePoint list, which automatically generates a unique ID number for every new row.
By setting up a Power Automate flow, you can bridge these applications so that immediately after a user submits the form, their data is saved, assigned an ID, and emailed back to them as a receipt.
Open SharePoint, create a new List, and add columns that match the questions on your Microsoft Form. The default 'ID' column will serve as your unique submission ID.
Open Microsoft Forms and create your workplace form to collect respondent information. Make sure to require an email address so you can send the receipt.
Open Power Automate and create an 'Automated cloud flow'. Choose the trigger 'When a new response is submitted' and select your newly created form.
Add a new step called 'Get response details' so the flow can retrieve the exact answers provided by the respondent.
Add a 'Create item' action linked to your SharePoint list. Map your form response details to the corresponding SharePoint columns.
Add a final action to 'Send an email (V2)'. Use dynamic content to include the respondent's email, the generated SharePoint ID, and a summary of their submitted details as the receipt.

Enable PDF Receipts in Microsoft Forms
If you do not have a Business subscription and can forego the unique ID, you can easily let respondents download a PDF receipt of their answers.
Looking for a Simpler Solution? Try WPS Office
If you find Microsoft 365 subscription tiers too restrictive or complex for your needs, WPS Office provides a free, lightweight, and comprehensive alternative that covers all your daily productivity tasks.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package for your device.
- 2. Install the Software: Run the installer and follow the on-screen instructions to complete the setup in minutes.
- 3. Start Creating: Open WPS Office and start using Document, Spreadsheet, Presentation, or WPS Form instantly.

Frequently Asked Questions
Can I automatically assign unique IDs natively in Microsoft Forms?
No, Microsoft Forms does not feature a built-in unique ID generator. You must rely on external databases like an Excel spreadsheet or a SharePoint list connected via Power Automate to assign a unique serial number.
Why can't I use SharePoint with my Microsoft 365 Family plan?
SharePoint is an enterprise-level collaboration platform designed for organizational use. Microsoft limits SharePoint access to Business, Enterprise, and Education plans, meaning Family and Personal users cannot create SharePoint lists.
Can I use Excel to generate receipt IDs instead of SharePoint?
Yes, you can use Excel Online as your database instead of SharePoint. By saving an Excel file on OneDrive for Business and using the 'Add a row into a table' action in Power Automate, you can assign IDs. However, robust automated workflows still often require a Business tier for stability.




