Using flow _ Excel online for Employee Appraisal

(0) Share

Report

Posted on by vijayn

Friends,

We would like to move from a paper-based appraisal process to an electronic format.

Our workflow is very simple - employee fills up the appraisal sheet/form --> manager reviews it and adds his/her comments --> HR will consolidate all the comments.

We don't want our employees to access other employees excel sheets.

We looked at creating folders for each department and separate sheet with unique access to the employee and their manager.

We see this as a cumbersome procedure, is there a efficient way to do this?

Categories:

General topics

I have the same question (0)

All responses (18)

Answers (2)

JohnAageAnderse 1,986 on at

Like (1)

Report
Hello @vijayn

Your scenario looks like it could be based on just using Forms, Power Automate and SharePoint Online.
Forms is used for employees to register their appraisals. They will have to login so their entry can be identified as coming from the employee.
Power Automate takes the Forms entries and stores them in SharePoint Online in a list dedicated for this. Only HR has contribute permissions to the list.
Power Automate grants the employee and his/her manager permissions to the entry.
Power Automate requests the manager to review the entry and add his/her comment(s), using an approval request (to indicate that the review is finished).
Power Automate then requests HR to consolidate the comment(s), using an approval request (to indicate that the consolidation is finished).

The above allows:
HR to perform the consolidation of comment(s) when requested.
Manager to perform reviews when requested.
Employee to view his/her entries.

Hope the above helps you on the way 🙂
Kind regards, John

Was this reply helpful? Yes No
vijayn 45 on at

Like (1)

Report

Thank you John for the reply.

My concern with the forms is it does not have save button for the employee to come back on a later date to complete the self appraisal? If its there, I am not sure how to use it.
The self-appraisal forms are usually long and can't be entered in one sitting. Is there an option to save a form?
Best Regards,

Vijay

Was this reply helpful? Yes No
JohnAageAnderse 1,986 on at

Like (1)

Report
Hello @vijayn

Thank you for clarifying the appraisal process 🙂 This changes point 1 and 2.

SharePoint Online is used for employees to register their appraisals in a list. The list is configured so that only the employee can view and edit his/her entries. When the appraisal is completed, the employee indicates this using a dedicated checkbox field (Yes/No column).
Power Automate takes the completed appraisal entries and moves them into another SharePoint Online list dedicated for this. Only HR has contribute permissions to the list.
Using a SharePoint Online list in 1. gives the employee time enough to fill out the appraisal at his/her convenience.
Kind regards, John

Was this reply helpful? Yes No
vijayn 45 on at

Like (0)

Report

Thats amazing.

When you say employee registers on list? is it possible to

1. Create a list and restrict the employee access only the list (link) emailed to him? I am worried what if the employee submits the list and can see the rest of the list items (other employee responses).

So I am looking 2 lists under 1 team site? list1 for self appraisal and list 2 for managers.

If you could share me a link on how to restrict users based on the content type or by permission given by Hr at a list level.

Was this reply helpful? Yes No
Verified answer

JohnAageAnderse 1,986 on at

Like (1)

Report
Hello @vijayn

In SharePoint Online, when you go into the List settings, there are Advanced settings, and in there you can set the Read access:
Read access: Specify which items users are allowed to read
Read all items
Read items that were created by the user
... and the Create and Edit access:
Create and Edit access: Specify which items users are allowed to create and edit
Create and edit all items
Create items and edit items that were created by the user
None
The blue marked setting options are the one to use 🙂
Kind regards, John

Was this reply helpful? Yes No
Verified answer

vijayn 45 on at

Like (2)

Report

You are amazing.

Just confirming my understanding. I send the New Item link to all employee asking them update their self appraisal.

2. I create flow and transfer the list 1 info to list 2.
3. I manually send the list containing the respective employees to their managers and ask them to complete the manager appraisal?

Was this reply helpful? Yes No
JohnAageAnderse 1,986 on at

Like (1)

Report

Hello @vijayn

You use the New item link only to start the employee do the registration of his/her appraisal. If the employee can't finish in one go, he/she just saves as is. The employee can then just go back to the list and see his/her unfinished appraisal and edit it to continue.

The flow will trigger "When an item is created or changed" in the 1st list and if the employee has marked the appraisal as finished, then it copies all the information to the 2nd list and delete the original appraisal (so it no longer can be edited by the employee).

The 2nd flow will trigger "When an item is created" in the 2nd list, identifies who is the manager of the employee, and informs the manager about the new appraisal to review 🙂
Kind regards, John

Was this reply helpful? Yes No
vijayn 45 on at

Like (1)

Report

Hi John

Iam in the last hurdle, i have created a flow and i am able to see the manager list getting updated when I enter info in employee list.

But I am not sure how to share the link to the manager so that he sees only his employees feedback.

I currently select the list item and use the copy link function and share it with a manager. But the manager says he is not able to see the link. Should i use any other button??

Was this reply helpful? Yes No
vijayn 45 on at

Like (0)

Report

The 2nd flow will trigger "When an item is created" in the 2nd list, identifies who is the manager of the employee, and informs the manager about the new appraisal to review 🙂
Kind regards, John
Just clarifying, for the 2nd flow i will use the "when an item is created" trigger in the flow is it?

Was this reply helpful? Yes No
JohnAageAnderse 1,986 on at

Like (0)

Report

Hello @vijayn

About the 2nd list 🙂
Yes, the flow trigger is when an item is created, as you want to process the item only when it has been copied from the 1st list.

The 2nd list must have permissions setup so that HR people have contribute permissions; Anyone else have no permissions.
The flow will grant the employee Read permission to his/her appraisal in the 2nd list, and grant the manager Contribute (or Edit) permissions to the employees appraisal. (search for action "Grant ...")

With the above the employee can only see his/her own appraisals (if you need that). The manager can only see and work with his/her employees appraisals. And HR can work with every appraisal.

Kind regards, John

Was this reply helpful? Yes No