Create due date reminder flow

(0) Share

Report

Posted on by Talko

Hi everyone,

The flow I'm trying to create should be pretty simple but something is missing.

I have a Microsoft list with few rows - Title and Expired on.

Title is text type and Expired on is date and time type.

Each row contains a title of a software, and license expired date.

The idea is that once a day, the flow runs and checks whether the expired date is in the coming 40 days or less.

If it is, send an email to remind me to renew license.

That's what I did -

The expression I used in the Filter query is -

Expired on 'formatDateTime(addDays(utcNow(), 40), 'yyyy-MM-dd')'

I'm probably doing something wrong because I get an error when trying to test it.

Could you guys help me out?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

annetoal 1,934 Moderator on at

Like (0)

Report

In your ODATA filter use le not eq.

If this helped, please mark it as a solution and give it a thumbs up.
Anne

Was this reply helpful? Yes No
Verified answer

Luis Arellano 247 on at

Like (1)

Report
For column names with spaces you'll have to check how SharePoint created the name internally, I think it depends on the SP version so, sometimes you can use
Expired_X0020_On
Newer version will just remove the space so, it will be like
ExpiredOn

To be sure about the column name, you can use
https://{YourSiteUrl}/_api/web/lists('{listId}')/items?$top=1

and search for "Expired".
Another way using power Automate is to use a "Get Item" action without any filter and see the output and again, search for "Expired".

Regarding the logic, just like @annetoal said, if it is in the "coming 40 days or less" you need to use le instead of eq. You'll get emails every day for items that will expire in 40 days, but maybe that is just what you want. Also, assuming you should have all items updated with a new ExpiredOn date that could be fine, but if you have historic items, you'll need to add an additional condition to discard those. Otherwise you'll get emails for items that expired long ago and might not be relevant now.

ExpiredOn ge 'formatDateTime(utcNow(), 'yyyy-MM-dd')' and ExpiredOn le 'formatDateTime(addDays(utcNow(), 40), 'yyyy-MM-dd')'

Was this reply helpful? Yes No
Talko 90 on at

Like (1)

Report

Thanks for the reply guys!
@LuisArellano I did try using the code you provided on filter query but I guess I messed it up somehow again.
First of all, you were right, the internal sharepoint name is indeed ExpiredOn, but I tried using it and it said the column does not exist.
Therefore I changed it back to Expired On and used the code you provided, but I still get an error :S

Do you see what am I doing wrong again?
Thanks

Was this reply helpful? Yes No
Talko 90 on at

Like (1)

Report

Okay nevermind guys, my bad. I supposed to type Expiredon, and now its working, Thank you!

Was this reply helpful? Yes No
KJohnson478 2 on at

Like (0)

Report

I am having the same issue with my flow test failing... I am not sure what I am doing wrong.

Was this reply helpful? Yes No