Hello,
Could you please help me with the following flow?
In short, an email needs to be sent to an person that was not included in 2 different databased. Both tables are unique data and will not overlap each other. Since both are a live document that will be updated, they can also not be merges together.
What I would like to do is that the unique ID number needs to be checked in the first table. If this table doesn't include the ID number, I would like it to check the second table. It can also be that the person is entirely included in both tables, therefore I would like to reach these people via Mail (power automate). I tried with the condition step, but the flow stops once the ID number is not found in either one of the tables.
Currently, I have this arranged for the flow but it stops at either of the get a row since the step is failed and will not continue further.