Others

How to Create a Form with Unique IDs and Receipts in Microsoft 365

Phi Hung VoPhi Hung Vo Nov 2, 2026 868 views

Question details

The user wants to build a workplace form that issues a unique submission ID and a downloadable receipt to respondents upon completion.

Creating a Form with Downloadable Receipts and Unique IDs
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a SharePoint List

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.

2
Build Your Form

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.

3
Set Up Power Automate Trigger

Open Power Automate and create an 'Automated cloud flow'. Choose the trigger 'When a new response is submitted' and select your newly created form.

4
Add Form Details

Add a new step called 'Get response details' so the flow can retrieve the exact answers provided by the respondent.

5
Create a SharePoint Item

Add a 'Create item' action linked to your SharePoint list. Map your form response details to the corresponding SharePoint columns.

6
Send the Receipt

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.

Use SharePoint and Power Automate to Generate Unique IDs
Subscription Limitations: This workflow requires SharePoint and premium connectors, which are only included in Microsoft 365 Business or Enterprise subscriptions, not the Family or Personal plans.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download the free installation package for your device.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to complete the setup in minutes.
  3. 3. Start Creating: Open WPS Office and start using Document, Spreadsheet, Presentation, or WPS Form instantly.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Includes WPS Form for fast, intuitive data collection and survey creation without complex setups.Access essential productivity tools completely free, avoiding expensive premium subscription tiers.Lightweight installation ensures smooth performance even on older devices.
microsoft office alternative - wps office

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.