cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neill_long
Helper V
Helper V

Link 2 SharePoint Lists for an approval

Hello,

 

I have 2 sharepoint lists.  One contains staff details, other stores items that staff requested.  They are linked using ID - MasterID.

 

I now need to create a Flow to do the following:

1. When new item is created in SP 1

2. Get items from SP 2 where MasterID in SP 2 matches ID in SP 1

 

Then need to add approval route but it is the first couple of steps that i don't know how to do if someone is able to explain how I can link this in Power Automate that would be great.

 

thanks

Alistair

1 REPLY 1
neill_long
Helper V
Helper V

thought i had managed to solve this but no:

 

I added in the filter query - MasterID Equals ID

 

My initial test worked and all good but when i have gone back to it, the dynamic content - ID - has removed itself from the field and is now blank.

 

neill_long_0-1642067980389.png

 

Am I doing something wrong here?

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,560)