web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Workflow email notific...

Power Automate

Suggested Answer

Workflow email notification

(0) Share

Report

Report

Posted on by DG-24022322-0

Workflow Details:

Send an email to the Owner of an item thirty days prior to the expiration date.

Workflow has: Recurrence, Compose, Compose, Get Items, Apply to each, Condition, True>For each 1>For each>Send an email V2

SharePoint List:

Column - Expiration Date
Column - Owner (Person or Group)

Note: Some items do not have expiration dates.

Multiple tests, multiple flows. The same problem occurs each time. I received an email for all items. It should only send me an email for the one "test" item I created today, to expire 30 days from today.

I have created similar flows without the Compose actions and the same result occurs.

Your feedback is greatly appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Sam_Fawzi 917 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @DG-24022322-0,

This usually happens for one of 3 reasons:

Get items is returning everything (no OData filter, or the filter can’t be evaluated), and

Your Condition is effectively always true (often because you’re comparing strings to dates / time portions don’t match), and/or

Items with blank Expiration Date are not being excluded properly.

Compose – Target Day Start (30 days from now at 00:00)
formatDateTime(addDays(utcNow(),30),'yyyy-MM-ddT00:00:00Z')

Compose – Target Day End (next day at 00:00)

formatDateTime(addDays(addDays(utcNow(),30),1),'yyyy-MM-ddT00:00:00Z')

Get items – use an OData Filter Query

ExpirationDate ge '@{outputs('Compose_-_TargetDayStart')}' and ExpirationDate lt '@{outputs('Compose_-_TargetDayEnd')}'

Replace ExpirationDate with the internal column name if different.

Hope this will help you with the issue.

Was this reply helpful? Yes No

Join the conversation