cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BigStev
Helper I
Helper I

How to pull in Data from two different SharePoint?

Good morning everyone!

 

I'm trying to get information from two different SharePoint lists.

I want to get the information from (List1) witch has the tracking number same as the new list (List2) when item witch was created.

So what I would like it to do is: when a new item is created in (List2) use the tracking number from (List2)to find the item in (List1) that has the same tracking number as the new item created in (List2) and then get Both the new item(List2) and the the old item (List1) so I can put both items information in email.

 

Please if some can help!

2 ACCEPTED SOLUTIONS

Accepted Solutions
mcin9781
Community Support
Community Support

Hey Steve if the above answer helped in solving your issue can you mark it as the suggested answer?

View solution in original post

BigStev
Helper I
Helper I

To anyone that uses this soliton please remember to make sure there are no spaces in your SharePoint list and when you type it into the Flow make sure there are no spaces in the Filter. 

 

This is what help me back was that did not use the space coding (_x0020_)

 

So if you do not want to use the above space code just make sure that there are no spaces in your SharePoint list.

View solution in original post

4 REPLIES 4
mcin9781
Community Support
Community Support

Hello Stev,

 

You will first want to create a trigger on when an item is created in list 2.

 

You can then use the "Get Item" action in order to get the item in the list with the specific tracking number. 

 

Then you could "Get Item" in list 1 with the tracking number pulled from list 2. 

 

Then you can use the "Add Attachment" action to add both documents to an email.

 

I have provided a list of the SharePoint Actions below.  It will give you a description of the actions and show you what is available to use when dealing with SharePoint.  If this was helpful please mark this as the suggested answer.

 

https://docs.microsoft.com/en-us/connectors/sharepointonline/#actions

mcin9781
Community Support
Community Support

Hey Steve if the above answer helped in solving your issue can you mark it as the suggested answer?

Hi thank you very much for the solution that you gave me.

 

 

BigStev
Helper I
Helper I

To anyone that uses this soliton please remember to make sure there are no spaces in your SharePoint list and when you type it into the Flow make sure there are no spaces in the Filter. 

 

This is what help me back was that did not use the space coding (_x0020_)

 

So if you do not want to use the above space code just make sure that there are no spaces in your SharePoint list.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,477)