web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Apply to Each failing ...
Power Automate
Unanswered

Apply to Each failing because result must be a valid array

(1) ShareShare
ReportReport
Posted on by 21
I'm making a flow that'll just update my SharePoint list items daily so the item age column will update. I'm getting the error pictured below. I've read many posts on this error and can't decipher what the solution is that I'm not doing. My list has 4 fields that are required: Submitter (lookup field from company directory that will display their name), LOB that's selected from a s dropdown, Title of the issue, and Issue Description.
 
I added an Apply to Each control and then added the Update Item control. The app automatically adds all the others you see in the flow pics below. I first selected the Submitter field (new Apply to each added), then LOB (new Apply to each added). The Issue Title and Issue Desc fields did not add any new loops. How do I overcome this error? Thanks!
 
Error:
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Flow:
Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at
    The issue with your flow is the nested applied to each actions. The reason that Power Automate has automatically added the Apply to Each actions to your flow is because the LOB Value - 1 and Submitted By or For Claims - 1 are multi choice/person fields. You need to parse the dynamic content before using it first by using a Select action. I cover how to do that in the YT Tutorial linked below.
     

    In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:
    1️⃣ Looping through a Single Item
    2️⃣ Creating Unnecessary Nested Loops
    3️⃣ Looping through an Unfiltered Array

    At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

    IN THIS VIDEO:
    ✅ How to avoid the Apply to Each action with a single item array
    ✅ How to use the item() function to access dynamic content in an array
    ✅ How to prevent unnecessary nested Apply to Each action loops
    ✅ How to use the Select action
    ✅ How to convert an array to a string with the Select action
    ✅How to use the Filter Query field
    ✅ How to count the number of items in an array
    ✅ How to use a condition control
    ✅ How to use the concurrency control
    ✅ How to set a top count
    ✅ How to use Compose actions for troubleshooting
     
     
    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • Sniderj1 Profile Picture
    21 on at
    Thank you!

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard