Unanswered

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

(0) Share

Report

Posted on by Pajjen

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.

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

Then, loops are created.

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?)..

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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".

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')))

Best regards,

Rimmon

Was this reply helpful? Yes No
Pajjen 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pajjen ,

What is the result of Condition? False?

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

Best regards,

Rimmon

Was this reply helpful? Yes No