Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Looking up a value from another Sharepoint List

(0) ShareShare
ReportReport
Posted on by 85

Hi everyone,

 

I am hoping you can help.  

 

I have a flow which is currently triggered from a sharepoint list by selecting an item, clicking automate and then the name of the flow.

 

The flow's initial action is then for a selected item with some input questions.  The input questions are then added to the relevant column in the sharepoint list.

 

What I am looking to do:

 

  • Check the Sub-Department column in the sharepoint
  • Lookup this value in another separate sharepoint list 
  • Return this value of administrator when a match is found*

 

*Currently this is a person field and can have more than one value in it.  Ideally I would want to return their e-mail addresses so I can CC them into an e-mail which happens later in the flow.

 

smodkins_0-1668084943667.png

 

Thank you so much in advance 

 

  • smodkins Profile Picture
    85 on at
    Re: Looking up a value from another Sharepoint List

    I have managed to figure this out using this resource 🙂 

     

    https://powerusers.microsoft.com/t5/General-Power-Automate/how-to-extract-email-address-from-a-sharepoint-person-or-group/td-p/124642 

     

    Thank you Anna for getting me on the right track and knowing what to search for.

  • smodkins Profile Picture
    85 on at
    Re: Looking up a value from another Sharepoint List

    Thank you Anna.  I have added in the filter query where 'Sub_x002d_Department eq' the dynamic field.  

     

    When I go to add the administrator to the CC of the e-mail it wraps the email in an apply to all so I think I am missing some steps.  Can you help?

  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Looking up a value from another Sharepoint List

    @smodkins  you can use Get Items action with filter query to fetch the items from another list based on sub-department value. 

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1