Power Platform Community Forum Thread Details

Linking Sharepoint Lists with Approval

Hello friends, can anyone help me please?

I created two forms.

1 - HR

2 - HOD

This is the summary of the flow:

When HR fills out HR form, it will go to the HOD's email, then the HOD will fill out the HOD form, then it will go to approval for IT Manager. Everything works fine but one thing.

I created a Sharepoint list that will retrieve the data from HR form cause I need the Form ID (Response ID) and the Employee Name to use it for the HOD form.

After HR form is filled out, it will automatically updated in the Sharepoint list above, and the HOD will receive this email:

When they click "this form", it will go to the HOD form and they have to fill out the Form ID.

This is my flow using Power Automate for the HOD flow:

Here I initialized and set the variable so that if the Form ID in the HOD form = Form ID (Response ID) in the HR form, it will set the Employee Name.

And finally, this is where the problem is, in the approval, for the Employee Name:

When I tested out the form and receive the approval request, the Employee Name is empty.

Supposedly, when I fill out the HOD form and stated the Form ID 10, it should match the Form ID in the Sharepoint list, and the Employee Name should show "saitama"