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?