@RezzaB I would recommend adjusting your flow a bit.
Compose - 3 Day Date
As mentioned in my previous post, you don't need the formatDateTime() function.
addDays(utcNow(),3,'MM-dd')
Get Items
Add a filter query to ensure you are only returning items that have a value in the Birthdate column. My column name is Birthdate, adjust that text to match your birthday column's internal name.
Birthdate ne null
Filter Array
As I mentioned in my previous post, looping through all items returned from the Get Items action and checking to see if the date is a match is not efficient. It would be more efficient to filter out the values returned that meet your criteria.
In this case, you need to filter out values returned from the Get Items action to see if the Birthdate date contains the 'MM-dd' from the Compose - 3 Day Date action.
Compose - Filter Array Count (optional)
This is an optional action. I like to add a Compose action to count the number of items returned in a Filter Array action in my flows. It helps with troubleshooting. When you run the flow to test it, this Compose action will display the number of items returned.
length([filter array body output here])
Run a test at this point so you can view the outputs which you will need for the next step.
In the Filter Array output, the text in red is what you'll need for your Send an Email (V2) action.
Apply to Each
Insert the Body dynamic content from the Filter Array action instead of the Value dynamic content from the Get Items action.
This way you are only looping through the Filtered Items.
Compose Action(s) – Optional
I would recommend using Compose actions to return the values that you will be using in the Send an Email (V2) action. Even before adding the Send an Email (V2) action, add Compose actions to return all the values you need from your Filter Array action.
With the Filter Array action the only dynamic content available to select is the Body which is why you will need to use expressions to access the content returned.
To return the birthdate of my item I used this expression:
item()?['Birthdate']
You will need to reference the outputs from the Filter Array action and use expressions to return the content.
To access a nested item such as an email address you will need to locate the outputs from the Filter Array action. In my case, I'm using the Profile > Email for testing purposes.
The expression I used to return the email address is:
item()?['Manager']['Email']
Again, the Compose actions are optional, however I would recommend at least ensuring your expressions are right before testing it out with the Send an Email (V2) action as it would be more efficient to develop your flow this way rather than waiting on an email to come through.
Once you've confirmed the expressions are returning all the correct values, you can insert the expressions directly into the Send an Email (V2) action—or use the outputs from your Compose actions!
Hope this helps!
