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 / Use "OR" function - "l...
Power Automate
Unanswered

Use "OR" function - "list rows from selected environment"

(0) ShareShare
ReportReport
Posted on by 2

Hi,

Im kind of new to this (Power automate) so i need some help.

So i created two "list rows from selected environment", pulling information from different tables. What i want is that if one of them has a value (ex f0b4ba99) then i want to post a teams message with information from both tables. 

Pajjen_0-1719385801313.png

When i choose parameters in the condition step im choosing X value from data verse 1 and Y value from data verse 2

Pajjen_1-1719386085143.png

Then, loops are created.

Pajjen_2-1719386145940.png

 

So when im running the flow and the outputs contains this values, the flow works fine.. But if one of the data verse does not contains this value the flow stops (due to the loops i think?)..

Pajjen_3-1719388274847.png

 



So is it possible to solve this somehow? So that if only one has the value it should continue

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    on at

    Hi @Pajjen ,

     

    If there is only one row in one of table, the flow doesn't stop. One row one loop, you can find that there is only one loop in first "Apply to each".

    vmengmlimsft_0-1719389611699.png

     

    If you want to send a team message when a column in Table1 has f0b4ba99 or a column in Table2 has a value of f0b4ba99, I recommend that you use the Filter array action and determine whether the filter result is empty to complete your request.

     

    Here is the method for your reference.

    and(empty(body('Filter_array')),empty(body('Filter_array_2')))

    vmengmlimsft_1-1719390082228.png

     

     

    Best regards,

    Rimmon

  • Pajjen Profile Picture
    2 on at

    Okey i have done above. What i forgot to mention in the post is that i want to send another value(values from data verse 1 and 2) in the teams message and when i add them "for each" is added and the teams message wont send.

    Pajjen_0-1719403219087.png

     

  • v-mengmli-msft Profile Picture
    on at

    Hi @Pajjen ,

     

    What is the result of Condition? False?

    Could you please show outputs of Filter array and Filter array2?

     

     

    Best regards,

    Rimmon

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

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard