Forum Discussion
Thuan Phan Van Minh
Jul 03, 2021Copper Contributor
How to get a number code after submitting a MS Forms
Dear All,
I am designing the online Health Declaration form by using MS Forms.
May I have a question that which way we can customize or add on an MS Forms in order for us to get a random code after submitting an MS Forms? I mean that that random code or number is a piece of evidence to prove we had completed the form as well as provide it to the Security Guard at the Gate.
May we use MS Power Automate Flows for this?
I am looking forward to receiving your experiences on this topic for me.
Many thanks.
Bets regards,
Thuan.
- RobElliottSilver Contributor
Thuan Phan Van Minh Yes I would use a flow in Power Automate for this to:
- get each form response as it arrives;
- save it to a list in SharePoint which will provide an audit trail as well as an ID number
- send an email back to the person who submitted the form with the details of what they entered on the form and the ID number from the SharePoint list.
The person can then print out the email or have it on their phone to show to the security guard.
We do exactly this with our IT ticket system and for other forms and it works well.
Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)- Thuan Phan Van MinhCopper ContributorDear Rob,
Many thanks for your sharing about this. It is helpful for me.
May I check that whether we can use SMS or not? Many guests don't have an email address because they are physical workers as well as we will lend them a iPad to declare in this case there will be a number code returned after submitting the form is better.
Or if we don't use MS Forms and Power Automate Flows, do we a free software may perform this function?
Thank you so much.
Bets regards,
Thuan.- RobElliottSilver Contributor
Thuan Phan Van Minh SMS is possible but they are premium Power Automate connectors so there will be a cost. I don't know of any free software that can interact with Forms and Power Automate.
Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)