web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Linking Sharepoint Lis...
Power Automate
Unanswered

Linking Sharepoint Lists with Approval

(0) ShareShare
ReportReport
Posted on by 78

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.

Qistina_0-1701672798244.png

 

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

Qistina_1-1701672963702.png


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

Qistina_2-1701673009936.png


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

Qistina_4-1701673114653.png

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.

Qistina_5-1701673176184.png

 

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

Qistina_6-1701673343190.png

 

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

Qistina_7-1701673416038.png

 

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"

Qistina_8-1701673525882.png


Can anyone help me please? Thank you very much

Categories:
I have the same question (0)
  • Verified answer
    v-yetonggu-msft Profile Picture
    on at

    Hi @Qistina ,

    Make sure the IDs on both sides of the 'condition' control are of the same type.

    Convert form input ID of type 'string' to type 'int'.

    I did a test for your reference.

    In my scenario:

    vyetonggumsft_0-1701678379300.png

    vyetonggumsft_1-1701678568156.png

    Best Regards,

    Sunshine Gu

  • Qistina Profile Picture
    78 on at

    Hi Sunshine Gu! @v-yetonggu-msft 


    Thank you so much for your help. It worked! Have a great day ahead 😄

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard