I am currently trying to build a flow which will receive all departments from specific users in my organization.
I have a SP-List with ~600 users filled with UPN.
In my PowerAutomate I load the UPN into an array and try to get the department back but I can not save my Flow with following expression:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Get_user_profile_(V2)' at line '1 and column '2612' is invalid. Action 'For_each' must be a parent 'foreach' scope of action 'Get_user_profile_(V2)' to be referenced by 'repeatItems' or 'items' functions.'.'.
My Flow looks currently like this: (Picture: Flow.png)
My Users Array Input looks like:
[
"John.Doe@company.com",
"Mark.Smith@company.com",
"barb.Wu@company.com"
]
GetUserProfile: (Picture: GetUser.png)
My target is to have a different SP-List with only the departments of the specified users.
if you need more information I am happy to share!
Thanks for the help in advance!
Marco
EDIT
-------
Seems like the pictures are not showing up in my post. I attached them now
removing the "current item" from the Apply to each and change it to expression item() solved my problem!
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
25
Share
Report
All responses (
Answers (
