Hello Everyone,I have created 3 different lists of Departments, Employees and Trainings, Employees and Trainings contain the lookup column from the department.
I will need a list of employees which contains the same departments as a training item
I have got data from the SharePoint lists and store it in Power Automate array variables.
Then I have to parse that array using ParseJSON action and compare department id using condition under nested Apply To Each.
But nested Apply To Each not working correctly. Kindly check the below screenshots,
Nested apply to each actions are never a good idea. Have a look at the following: https://www.damobird365.com/one-to-one-relationship-between-data-in-flow/ where I show you how to create an array from two excel tables and a list. The exact same principle applies to you.
Please let me know how you get on.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Cheers,Damien P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.