AnsweredAssumed Answered

Office 365 Lookup Field Querry

Question asked by jonathankite on Oct 5, 2016
Latest reply on Oct 19, 2016 by ohrenstoepsel

I have an Office 365 List Query (List Query 1) action configured that selects the ID's from a list (List A) that is used as a lookup column in List B based on certain conditions.

 

If I want to then use the returned items from List Query 1 as the conditions for List Query 2 into List B to retrieve items who have matching values in their lookup columns (Lookup column into List 1).  I'm not sure how to do that.  Using the ID's retrieved from List Query 1 into List 1 as the condition of the query into List 2 does not work (nor do text based versions since it's a lookup column).  

 

How can I get this to work?  Do I need to somehow concatenate the ID and the name from List Querry 1 to format it into a lookup value?

Outcomes