Two SharePoint Lists, one as a reference

Copper Contributor

Hi, 

 

I'm working on a personal project and could use advice. I'm new to power automate and self taught. I've built a lot of flows but this one is going to be my most complex. I have one list that I'm keeping track of people using a SharePoint list person field called DirectoryName. There is a second list that is created when someone makes a request RequestName. I've been trying to use getitems from both sharepoints and then using a condition to find when the two fields match to return another column. 

 

I've tried matching on both DirectoryName's DisplayName and Email attributes against the CreatedBy matching attributes. I get nowhere. Lately it just gets into an infinite loop. I did search the forums and found the below, but it doesn't really match what I'm trying to do. Any suggestions or guidance would be very appreciated!

 

 

get items from another sharepoint list using power automate - Microsoft Community Hub

0 Replies