How to Add Sequential Numbers to Power Automate Email Subjects
Question details
The user wants to generate and include a custom, sequentially incrementing number in the subject line of automated emails triggered by Microsoft Forms.
- Product
- Power Automate
- Device & OS
- not provided
- Scenario
- Setting up an automated email confirmation flow for Microsoft Forms responses where each email subject contains a unique tracking or booking sequence number.
- Observed behavior
- Power Automate does not retain a built-in custom booking sequence between flow runs, requiring a persistent external data source to store and increment the current number.
Ensure you have the necessary edit permissions to create and modify both your Power Automate flows and a SharePoint list on your organization's SharePoint site.
Use a SharePoint List to Track and Increment Sequence Numbers
Because Power Automate is stateless between runs, you must create a dedicated SharePoint list to act as a persistent database that stores your current sequence number.
A SharePoint list allows the flow to fetch the latest number, use it in the email subject, and then update the list with the next number so it is ready for the subsequent form response.
Navigate to your SharePoint site and create a new blank list. Add a 'Number' column to store your sequence values and create a single initial row with your starting number (e.g., 1).
In your flow, immediately after the 'When a new response is submitted' trigger, add the SharePoint 'Get item' action. Point it to your newly created list and specify the ID of the row holding your sequence number.
Add a 'Compose' action that uses an expression to add 1 to the fetched sequence number. Then, add a SharePoint 'Update item' action to overwrite the existing list row with this new incremented value.
Add the 'Send an email (V2)' action to your flow. In the 'Subject' field, write your desired email title and use the dynamic content menu to insert the sequence number you fetched from SharePoint.
Manage Data and Spreadsheets Easily with WPS Office
If you routinely work with form exports, lists, and business logic, WPS Office offers a free, lightweight, and highly powerful alternative to Microsoft Office. Enjoy a familiar interface, seamless migration, and excellent compatibility for managing your documents and spreadsheets.
- 1. Download the Software: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install the Suite: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open Your Office Documents: Launch WPS Spreadsheet or Writer and open your existing Microsoft Office files instantly with preserved formatting.
Frequently Asked Questions
Why can't I just use a variable in Power Automate to count the responses?
Variables inside a Power Automate flow are only retained during that specific flow run. Once the run finishes, the variable resets. To keep a running count across multiple form submissions, the number must be stored externally in a persistent location like SharePoint.
Can I use Excel Online instead of SharePoint to store the sequence number?
Yes, you can store the sequence number in an Excel table saved on OneDrive for Business or SharePoint. However, SharePoint lists are generally recommended because they are less prone to file-locking errors during concurrent or high-volume flow triggers.
Where can I find sample flow templates for sequential numbering?
The Microsoft Power Automate Community forums feature extensive discussions and visual screenshots of successful flow structures. Searching the community for 'Create a sequential number in a SharePoint list' provides exact template configurations.
