Forum Discussion
Want to create a Form for Hiring process, but should have 3 level approval
Dear All, I want to create a Form, in which the user creates a Requisition for his team along with few more information. However, this has to go to his Manager for approval, after which it ha...
Hi Damien_Rosario,
Thank you so much for your kind words.
I have created the form as a template and it looks to be good. One of the Teams want to use it.
However, this form does not have any uinque ID column.
So I have 2 questions here:
1. how to get unique ID for each form submitted.
For example: if there are 20 to 30 forms submitted over a period of time; if I want to search for a particular Request, how to work around it.
2. also is there a possibility of displaying a table that I have in my Excel file that contains some hiring data, so that the approver can refer to it and Approve
Thanks
Sunil B S
Thank you so much for your kind words.
I have created the form as a template and it looks to be good. One of the Teams want to use it.
However, this form does not have any uinque ID column.
So I have 2 questions here:
1. how to get unique ID for each form submitted.
For example: if there are 20 to 30 forms submitted over a period of time; if I want to search for a particular Request, how to work around it.
2. also is there a possibility of displaying a table that I have in my Excel file that contains some hiring data, so that the approver can refer to it and Approve
Thanks
Sunil B S
sunilbsrv2k Just look at the spreadsheet behind the form responses, it has an ID column.
For the Excel table you might have trouble adding it into an approval email as the detail field is in markdown.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
- Hi Rob_Elliott,
I have created this form in "Approvals" app in Teams, as I could not find multi-level approval option in MS Forms.
Regarding the details, it is about the Hiring data, like "Present Headcount", Required Head Count" etc are stored in a file. When the approver gets the request to approve, he should be able to view those details in the Form itself, rather than going to some other file. Wanted to check if it is possible?
Please Note: I have a question regarding another task, for which I will be creating another thread.
Thanks