I've been going in circles trying to get my Power Automate flow to work and would like to know if anybody has a fix for my problem. What I'd like my flow to do:
In my excel sheet on SharePoint, there's a column that has "Contract End Date". Everyday in the morning at 9:00am to have an automatic recurrence flow to check if any of the values under "Contract End Date" expire in 30 days-using "addDays(utcNow(), 30, 'yyyy-MM-dd')", and for those contracts that do expire in 30 days to send an Email to a validator with a table that has the name of the contractor expiring and the date it does.
Obstacle: The current issue with my flow is that when it sends the Email, it'll send multiple counts of the email to each person. For example, if 5 people's contracts were to expire in 30 days, my current flow would send 5 of the same email with the table of the 5 people's contracts and names to the validator. I was wondering if anybody had a workaround.
Edit:To clarify my need, I only want to send the list of people expiring to one person, to myself for example. The current problem that I'm encountering is that if the "Send an Email" is inside the "Apply to each" and sent to ME, it'll send me 5 of the same emails if there are 5 people expiring. If the "Send an email" is on the outside the "Apply to each", if the condition is true, it works properly. The problem here is that if the condition is false, it'll still send an email with "Null,Null" repeated .