Hi @girijai,
Could you please share more information about Birthday SharePoint list?
I suppose that there is Date column in Birthday SharePoint list which is used to compare with today’s date.
Do you want to check the Date column of a new created item?
Or filter all items whose Date column meets the condition in Birthday SharePoint list?
- If you want to achieve the first one, you only need to add a Condition. If the condition is met, send an email to specific person. In Condition box, click “Edit in advance mode” and type the following formula:
@equals(formatDateTime(triggerBody()?['DateColumn'],'MM/dd'), formatDateTime(utcNow(), 'MM/dd'))
2.If you want to achieve the second, it is not necessary that use “When an item is created” as a trigger. We can use a recurrence trigger to instead of it.
Firstly, we need to get all items with “Get items” action and do some filter with “Filter array” action. In “Filter array”, configure From to Output of “Get Items” action and type the following formula in advance mode:
@equals(formatDateTime(item()?['DateColumn'],'MM/dd'), formatDateTime(utcNow(), 'MM/dd'))
Then we need to add “Apply to each” to output of “Filter array” action. In “Apply to each”, we add “Send an email” action.
In order to send HTML View, we can add “Create HTML table” action before sending an email. Configure From property of “Create HTML table” action to an array. In body property of “Send an email”, we add output of “Create HTML table” action. Set Is HTML property of “Send an email” action to Yes.
Besides, in order to add an attachment, we can configure Attachment Name and Attachment Content property as below:
Best regards,
Kris
