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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow Failing: Weekly ...
Power Automate
Answered

Flow Failing: Weekly Status Update via Email

(0) ShareShare
ReportReport
Posted on by 4

Question:  

I have a Power Automate flow that keeps failing. This flow runs weekly and pulls items from a list to email the owner if the status is "Open," "Ongoing," or "Extended." I am trying to understand what is wrong with its structure. Based on the steps shown in the screenshot, could someone explain why this flow is failing?

Steps:

  1. Recurrence
  2. Get items
  3. Apply to each
  4. Switch
  5. Case: Equals> Open → Send an email (v2) (Skipped)
  6. Case: Equals> Ongoing → Send an email (v2) (Fails with “ExpressionEvaluationFailed”)

Case: Equals> Extended → (Skipped) with Error (ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied.)


Errors: 

  1. Run details show the error:The execution of template actionApply_to_each_3failed: the result of the evaluation offoreachexpression is of type Object. The result must be a valid array.
  2. The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@items('Apply_to_each')?['Disposition']' is not valid. It is of type 'Object' but is expected to be a value of type 'String, Integer'.
  3. Flow: 
5. Error 
 
Flow.png
Error.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:
I have the same question (0)
  • Suggested answer
    Sajeda_Sultana Profile Picture
    189 on at
     
    The issue is that the flow is treating a single object as an array. Since Get items already returns the records and Power Automate automatically creates an Apply to each to process them, you don't need additional Apply to each actions inside your Switch cases.
     
    The error:
    "The result is of type 'Object'. The result must be a valid array."
    usually appears when an Apply to each is expecting an array but receives a single object instead.
     
    I would also check the Switch action. If you're using a SharePoint Choice column for Status, make sure the Switch is evaluating the status text value rather than the entire Status object. For example:
    items('Apply_to_each')?['Status']?['Value']
     
    A simpler structure would be:
    Get items
       ↓
    Apply to each
       ↓
    Switch (Status Value)
       ├─ Open → Send Email
       ├─ Ongoing → Send Email
       └─ Extended → Send Email
     
    Remove the extra Apply to each actions from the Open, Ongoing, and Extended cases and place the Send email action directly inside each case. That should resolve the error.
     
    ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

    ❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

    🏷️ For follow-ups  @Sajeda_Sultana
     
  • Suggested answer
    11manish Profile Picture
    3,333 on at
    The root cause is not the email action itself but the fact that the Disposition field is being passed as an object where a string is expected, and an Apply to Each loop is attempting to process an object instead of an array. Correcting the field reference to use the actual value and removing any unnecessary loops should resolve the flow failure.
  • Verified answer
    chiaraalina Profile Picture
    2,425 Super User 2026 Season 1 on at
     
    In the Switch you need the Status Value (not Status only). You already have that in your second screenshot.

     
     
    For the Send an email (V2) action your Apply to each has to look like this:

    Owner is the name of your multiselect Person column.
     


    Not like this:

    Otherwise you will get that error.

    Let me know if it worked!
     
  • Sajeda_Sultana Profile Picture
    189 on at
     
    Just following up to check if everything is working now. Let me know if you still need any help - I’m happy to assist.

    If the issue has been resolved, please consider marking the answer as solved so it can help others with a similar question.

    Thanks, and have a great day!
  • MP-22061759-0 Profile Picture
    4 on at
    Thank you for responding!!

    ***UPDATE*** 
     
    It worked! Here are the steps I took:  
     
    1. On the switch, I had to update the value for the status in the listing to match the exact name it’s called: `@items('Apply_to_each')?['STATUS']?['Value']`.  

    2. I removed all the extra "Apply to each" actions under the switch. I assigned the owners to "Select an output from the previous step" and used `Owners.Email` in the "Send an email (V2)" action, and it worked. 
     
    Thank you, guys, for helping me out! 
     


     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard