Skip to main content

Notifications

Power Automate - Using Connectors
Answered

How to pull in Data from two different SharePoint?

(0) ShareShare
ReportReport
Posted on by 89

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!

  • Verified answer
    BigStev Profile Picture
    BigStev 89 on at
    Re: How to pull in Data from two different SharePoint?

    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.

  • BigStev Profile Picture
    BigStev 89 on at
    Re: How to pull in Data from two different SharePoint?

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

     

     

  • Verified answer
    mcin9781 Profile Picture
    mcin9781 on at
    Re: How to pull in Data from two different SharePoint?

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

  • mcin9781 Profile Picture
    mcin9781 on at
    Re: How to pull in Data from two different SharePoint?

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics