I have tried a flow for this but it ends up sending the information of the other email address as long as the daysleft is 3
so from the first table, this is what email@example.com is receiving:
this is my flow. I made the union so that only 1 email is sent to the email mentioned in the email column in the first table above.
If I do not do that, it will send one email per row to the same email address. However, with this the above mentioned 3rd table is sent to the respective email. Hope you can help, I am not sure if I am missing any filters so that only those items to the respective email will be sent.