Retrieve data from a second list after data matches using apply to each

[dmooreii]

I have 2 lists - employee offboarding and employee loner equipment.

I use a form to input termination date and save it to the employee offboarding list.

I am building a scheduled flow that checks the termination date 4 times a day during working hours.

I use condition to check when the date from the employee offboarding list matches today's date.

At that point I need to do a second get items to search the employee loaner equipment list for the selected employee and retrieve all the loaner items. 

I am not able to use Get Items while in the Apply To Each loop.

Not sure how to accomplish my requirement.

Maybe need to rethink and do it another way ?

[Pstork1]

First, why can't you do a Get Items on the second list while you are inside the Apply to Each loop?

If the second list isn't too large an alternative would be to do a get items on the second list before entering the loop.  Then you can filter the array created by that Get items while you are in the loop.  Either approach will work.  Using a Get items outside the loop will lead to better performance, but won't work if the list is too large.

[dmooreii]

I get an error - "The operation can only be used at the top level"

Let me show you how I am attempting to do this Flow:

1. Reoccurrence - Check 4 times daily to see if HR has entered a term date for the employee on the employee offboarding list

2. Get Items and Filter - Check if term date = todays date and that email notice has already been sent to HR. Also retrieve employee name.

3. Initialize Variables (loaner equipment) to be added to email message to HR

4. Get Items - check employee loaner equipment list to find equipment loaned to the employee and build the variables

5. Send email to HR which includes the list of equipment (variables)

[Pstork1]

Variables can't be initialized inside a Loop.  You have to Initialize them above the loop and then you can use Set Variable inside the loop.  That's why you are getting an error.

[dmooreii]

Can you provide example of how I can add a field from employee loaner equipment list to a variable array if other field in the same list matches employee name.

What would the variables in the array be named if there are multiple employee name matches in the list ?

[Pstork1]

You may be doing it the right way already.  The problem is that you are trying to use the Initialize variable action inside a loop.  You can't do that, that's why you are getting an error.  But if you initialize the variable with no value prior to entering the loop you can use the Set Variable action inside the loop to change the value of the variable.  Your just using the wrong action in the wrong place.