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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

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
    Microsoft Employee 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 482

#2
11manish Profile Picture

11manish 280

#3
David_MA Profile Picture

David_MA 268 Super User 2026 Season 1

Last 30 days Overall leaderboard