Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Getting Item from Sharepoint list - lookup NOT on ID column

Dear Community!


Been scrambling my head around this and looked around but couldn't find the right answer. 


I have the following flow:

1. when a new SP list item is created then

2. gets a Row - from an excel file stored on one drive.

3. sends email with the data looked up from that excel.

This works well. 

The excel file has to be updated every day. 


What I want to change is Step 2 - so replacing excel with another SharePoint list ( that I already have).

However I cannot achieve this because in Get Item step I can only lookup by ID of the list item and I want a different column


so instead of the ID on the branch I want another column which apparently isnt available.


Any ideas? 


many thanks!





Helper II
Helper II

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (2,963)