Power Platform Community Forum Thread Details

I want send email, When the sharepoint list item "To" coloum data is equal to today.

That email body should contain a table below

S No	AMC Description	Category	PO Number	From	To
2	amc 13	Choice 1	40,754,545	12/31/2024	1/5/2025

and Subject line having " AMC Due on Today"

But somehow i have managed to create a alert email, But I Could not be able to produce a table like above in email body like above. So requesting experts to Kindly help me to setup a flow to achieve this requirement.

Thanks a lot in advance

Regards,

Singaravelu S

Categories:

Building flows

You can do the following:

Create a scheduled flow that runs daily at the time you want the e-mails to be sent.
Then use a Get items action with a filter query on the To field where the current date is equal to the "To" date.
Add a condition to check if items were found.
If so, in the yes side of the condition and an Apply to each on the items and send the e-mail.

The flow will look like this with the exception of the trigger:

This is how you configure the filter on the Get items action:

The ge expression is formatDateTime(startOfDay(utcNow()),'yyyy-MM-dd')
The lt expression is formatDateTime(addDays(startOfDay(utcNow()),1),'yyyy-MM-dd')
And be sure to replace Created with the internal name of the To field in your SharePoint list.
The condition uses this expression: length(outputs('Get_items')?['body/value'])