Reoccurance reminder based of expiry date in sharepoint list

(0) Share

Report

Posted on by CC-15071724-0

I have created a reoccurance power automate workflow that will send an email reminder based of a sharepoint list expiry date column for 60 days, 30 days and 15 days before it expires to multiple people in the sharepoint list.

The issue is the expression result always ends up as false, so itnever sends the reminder email even though the outputs match the condition of 30 and 60 days in my testing see attached.

Categories:

Building flows

power auto result...

power auto 1.png

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Tomac 3,953 Moderator on at

Like (0)

Report
It looks like the results of your compose action DaysUntilExpiry is returning extra line breaks, which will cause this issue.

You can resolve this one of two ways:

Modify the expression in your Compose action to remove the extra characters and convert the string to a number

Wrap the Outputs dynamic content in your Condition in functions to remove the extra characters and convert the string to a number

Either place you choose to put the wrapper, it will look like this:

int(replace(replace(YOUR VALUE HERE,'\',''),'n',''))

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

Does your Get items action use a Filter Query to reduce the number of items it retrieves? If not, do you expect to have more than 100 items in the list? And if so, could it eventually grow beyond 5,000 items?

If your list has more than 100 items, be aware that the Get items action only retrieves the first 100 by default. To get more, you’ll need to enable pagination and set a suitable threshold for the number of items to return.

If your list might exceed 5,000 items, performance will degrade significantly without a filter query. In that case, it’s important to index key columns—especially the expiry date field—so you can use a Filter Query to retrieve only the relevant items. Once your list exceeds 5,000 items, any field used in a filter must be indexed for the query to work properly.

Was this reply helpful? Yes No
CC-15071724-0 2 on at

Like (0)

Report

Thanks both for you assistance so far, I really do appreciate it.

@David_MA The test list only contains two items. I dont expect the list to be any greate than 150 - 200 items over time. I do have a query filter which is

ExpiryDate ge '@{utcNow()}' and ExpiryDate le '@{addDays(utcNow(), 60)}'

shouLd I keep this?

@Tomac

My expression in the DaysUntilExpiry is currently the folloowing, what do you recommend I alter it to?

@{div(sub(ticks(items('Apply_to_each')?['ExpiryDate']),ticks(utcNow())),864000000000)}

Was this reply helpful? Yes No