When you create an item in SharePoint from a MS Response, every item will have an auto-generated ID. To create a custom ID as per your specifications, you'll need to create a column for it. I'd recommend a text column for this.
For demo sake, I'm storing my values in a Compose action.
Range
In another Compose action insert an expression and use the range() function. The range() function generates and array of integers starting from a certain number.
For the first number enter a 1 (since that is where you want the numbers to start). Add a comma then the second number. For the second number insert the output from the Compose action above. In your case, you can use the output from the form response.
Run a test. Review the output of the Compose action. It will output an array of numbers from 1 to 3 in my case.
Loop Through Each Number
Add an Apply to Each action. Insert the output from the Compose action above. This action will loop through each item in the array. To confirm this, you can also add a Compose action to output the Current Item. Compose actions can be helpful to troubleshoot and build your flow.
Run a test and review the outputs.
Prepend the Response ID
In the Compose action, place your cursor at the start and insert the Response ID. I'm using the output from the Compose action in my case. Don't forget to add the period between the Response ID and the Current Item.
Run a test. Review the outputs. You'll then need to insert the Create Item action inside the Apply to Each action as you want to create one item for each custom ID. Use the outputs of the Compose action in the Custom ID field.
For more details on how to create an SP item from a MS Form submission refer to this YT Tutorial:
How to Get a Microsoft Form RSVP Response into a SharePoint List
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.
At the end of the video I’ll show you a few tips and tricks on working with a SharePoint list.
IN THIS VIDEO:
✓ How to get a Microsoft Form Response into SharePoint
✓ How to get a Microsoft Form ID
✓ How to get a Microsoft Form response
✓ How to Build a Microsoft Form with Conditional Fields
✓ How to used Branching in Microsoft Forms
✓ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column
✓ How to parse a Microsoft Form multiple choice response as string of text
✓ How to convert a text response to a number
✓ How to use the Switch action
✓ How to create a custom email confirmation for a Microsoft Form submission
✓ How to Create a Custom View in a SharePoint list
✓ How to use the Compose Action
✓ How to write Power Automate Expressions
Hope this helps!
Consider giving me a
❤️ if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on
YouTube👉 Tips and Tricks on
TikTok and
Instagram
