Hi everyone
i really need some help here.
I have a excel workbook which creates the following tables.
they are being populated by a filter formula and is dynamic.
It get filled with any date that it either 1 or 2 days before today
so on the 13-06-2024 it would send and email that has the date registered as 15-06-2024 and again om the 14-06-2024
(pure for test the real values will be different.)
column 1 is storing the first value of the 2 (you can change the days before in the excel sheet)
So the table is only showing row that need to get an email.
The Dateint i the end is show if it is the first or second version that they need to recieve.
Now i have tried to create a flow that takes in these value, and make a comparison between the dateint in table1 and the Column1 in table2
If the the dateint value matches column1 when it should send email 1 else email 2.
Here is the flow i have created but i creates alot of different behavior.
First: list rows present in a table only list the values with dateint as 2 but not the ones with dateint as 1
and i get the following errors in:
For each: ActionFailed
An action failed. No dependent actions succeeded.
Condition:
ActionFailedAn action failed. No dependent actions succeeded.
for each 1:
ActionBranchingConditionNotSatisfiedThe execution of template action 'For_each_1' skipped: the branching condition for this action is not satisfied.
for each 2:
ActionFailedAn action failed. No dependent actions succeeded.
send an email v2 :
ActionDependencyFailedThe execution of template action 'Send_an_email_(V2)' is skipped: dependant action 'For_each_1' completed with status 'Failed' and code 'NotSpecified'.
Anyone who can help me. This is proberly just a small error somewhere.
