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 / Flow Condition Not pro...
Power Automate
Unanswered

Flow Condition Not processing conditional logic correctly

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I have been working on a tough flow for the last few weeks. Here Is my latest issue: (I'll also post pictures of the flow below this article for ease)

Please also note I have a very basic understanding of flow code and logic, it is possible I've made a rookie mistake.

 

First, the flow collects items from a sharepoint list named: Users Contacted - It then takes that data and dumps it into a variable (UsersContacted)

Next, the flow collects items from a sharepoint list named: Form Completed - It then takes that data and dumps it into a variable. (FormCompleted)

For the next step, we have an apply to each, with a value input from the step where we pulled the sharepoint items from the Users Contacted list.

Next, still inside the apply to each I added a condition to check if the variable "FormComplete" contains the users e-mail. (From users contacted list.

Condition:

Yes- Apply to each with the respective value from "FormCompleted" and then send an e-mail to the user.

No - Create a sharepoint item in a new list, called Users Being Reminded. (To keep track of who the flow is currently set to remind)

 

My issue is this:

The first flow run always follows the logic and does exactly what I want, however...any subsequent attempts have unexpected outcomes, IE the user gets a reminder email even though they are in both the users contacted list and form completed list.

 

What am I missing? Please help me Flow-naughts!ReminderFlowHelp1.pngReminderFlowHelp2.png

Categories:
I have the same question (0)
  • MJain Profile Picture
    2,450 on at

    Hi @Anonymous ,

     

    You are basically trying to filter FormCompleted list by UserContacted  list. Do these list only contain email ? If no then your condition will not work. 

     

    Inside apply to each use Filter Array action and input should be FormCompleted and then use the condition which have used.

     

    Thanks

  • Community Power Platform Member Profile Picture
    on at

    Hello @ManishJain 

     

    I've tried this but still get the same result, could you post an example flow for me?

     

    Thank you!

  • MJain Profile Picture
    2,450 on at

    Hi @Anonymous ,

     

    Can you please confirm what UserContacted and FormCompleted list comprises of ? Is it just holding emails of contacts?

     

    For your reference to filter array do look at : 

     

    https://sharepains.com/2018/12/18/microsoft-flow-filter-data-in-an-array/

     

     

    Thanks

  • Community Power Platform Member Profile Picture
    on at

    Sorry @ManishJain,

     

    Yes, my SP Lists only contain one column name UserEmail1, UserEmail2, and UserEmail3 respectively. Of course, we know Flow won't show the title column name as anything other than "Title" so we may as well call that column Title.

     

    I will take a look at your link, thank you!

  • Community Power Platform Member Profile Picture
    on at
     

    @ManishJain

    Here is my error after filtering the array:

    Flowerror.png

  • MJain Profile Picture
    2,450 on at

    Hi @Anonymous ,

     

    Please use compose action prior to using a condition after filter array and provide your input like 

     

    first(body('Filter_array'))

     

    This will help you to understand whether you really need a loop after filtering.

     

    Thanks

  • Community Power Platform Member Profile Picture
    on at

    Hello,

     

    I am still struggling with this Flow.

     

    Maybe there is a way I could have the flow turn the 2 sharepoint lists into another form of data flow could better work with?

     

    PLEASE HELP!

  • MJain Profile Picture
    2,450 on at

    Hi @Anonymous ,

     

    The error after filter array is happening so I would put a condition to check if filter array returned some data like this 

     

    empty(body('Filter_array) is equal to true , if yes do nothing , else in no part do your logic.

     

    Thanks

  • Community Power Platform Member Profile Picture
    on at

    Thanks for that tip @ManishJain 

     

    I've attached a new photo of the latest error:

    ReminderFlowHelp3.png

  • MJain Profile Picture
    2,450 on at

    Hi @Anonymous ,

     

    Can you please share screenshot of error .

     

    Thanks

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 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard