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
I completly rebuild the whole thing and use a different solution which works perfectly.
As per error your for each 1 is failed..check why it is failed...what are you doing in it?
open the flow history and check the values and exact error from there
cheers