Forum Discussion
Want to create a Form for Hiring process, but should have 3 level approval
Thanks for your response. I tried few things with MS Forms - Power Automate combination... but it didnt work.
Hence wanted to check if there was any other way. I have now tried "Approvals" app and it has worked to a certain extent. But I am not able to load any data available to me in a file.
Hi sunilbsrv2k
That workflow you've started has you heading in the right direction. You can add to it and have that data downloaded to a file or to a SharePoint list, etc as you require.
I suggest mapping your process flow so you can further adjust the solution in Power Automate.
Let us know how you want to proceed and we'll do our best as a community to support you where we can.
Cheers
Damien
P.S. In the meantime, you can explore the options for downloading content to a file such as below. It will simply depend on how you want the output to be (via email, email attachment, PDF, word doc, HTML file, etc):
- 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 SHi sunilbsrv2k
Hopefully, my mock-up flow below will give you some ideas to assist you in your solution. Can possibly do a teams meeting to deep dive into the requirements if our timezones allow.
Here's a simple flow where I can extract the submitter automatically from the form and then use those details to look up their manager (assuming your org has populated this detail in the Office 365 account). I then trigger an approval to the manager and once approved, it will notify the Department Manager to also approve/reject.
Your first question - 1. - To get the Form ID of the submission, you need to reference the Response id field. This will mirror what you see in the results Excel spreadsheet of the form.
Your second question - 2. - You could put a URL in the approval email to the live spreadsheet that the Department Head can review before approving. Not sure if you can embed live data as I have never tried, but the link to the data source should be sufficient I'd say.
Observation
I did see that you may have been indicating to have the entire process in one form. If this is so, it can't be done as once the form is submitted, it can't be revisited by others.
The approval process I've highlighted will allow each touch point to manage their part and then flow to the next person.I suggest using a SharePoint list or something like it to capture each submission and each response in a single record. Then you can search for the desired ID and can see the status for each item that you need to action.
This way, all information is captured in a single source and will be easy to filter and action.
Hope that helps in some way. Happy to chat more or to be corrected if I have misunderstood anything.
Best wishes
Damien
- Hi Damien,
Thank you so much for your detailed answers and observations.
As you mentioned, even I would like to have a call than a chat as this will be limited.
Further, its true that I am trying to implement both in one form and the form is created in the "Approvals" app of Teams.
The Process flow mentioned in your answer, the Response ID etc , I guess, are part of the Power Automate and MS Forms.
And the options in the "Approval" forms are limited. Hence requesting your guidance.
I am facing some issue in Power Automate and hence Process flow is failing.
Thanks and Regards
Sunil
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
- Excel file that contains some hiring data?
Is the Excel file downloaded from MS Forms quiz result?
If you show some data,it maybe easier to be understood.
