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...
RobElliott
Jul 05, 2021Silver 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 MinhJul 05, 2021Copper 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.- RobElliottJul 05, 2021Silver 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)- Thuan Phan Van MinhJul 06, 2021Copper Contributor