
Announcements
Hi,
I'm trying to send an email to a list of 'Approved Users', who are listed in a sharepoint list. For each email, I'd like to address the approved user by their first name. My flow fails with the following error: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')?['ApprovedUser']' is of type 'Object'. The result must be a valid array.
Has anybody had this before? Admittedly I'm very, very new to Power Automate, so I've probably overlooked something basic.
Kind regards,
Stuart.
Hi, it looks like there are to many loops in your flow. This happens when the list object is an array like Person or Group. To stop the flow from creating the for each loops automatically you need to type out the object that you are targeting instead of trying to select it from the list. Eg. I have a list where the column PolicyOwners is a Person or Group so to target the first Display Name I use the following: