Easily create a SharePoint “Timer Job” using Microsoft Flow

Easily create a SharePoint “Timer Job” using Microsoft Flow

Let’s consider a case in which you have a list with a field storing a Date of Validation of the item, and if you haven’t checked this item and updated this value in 3 months, you should get a reminder of an “old item”.

Start with the recurrence trigger, setting it to run every 12 hours for example:

After that, generate the calculated date by choosing a date action (Subtract from time).

Then, use the SharePoint Get Items action, but expand the advanced session, and set the ODATA Filter Query to your date field as in the example below. 

You can limit columns by view too if you prefer, preventing threshold issues. A good practice would be to index the filtered fields on the SharePoint list settings too.

After that, you just need to create your e-mail message pulling info from the returned items.

Remember to enable HTML in your message, so that you can get a better layout…

Now your “Timer Job” is ready. Every 12 hours (or the time you choose), the email destination is going to get a notification for every item that needs to be checked.

Simple as that!

Marcos Zanre

Sr. Technical Specialist

6 年

Excellent tip!

Sander van den Hoven

Senior Software Engineer @ Microsoft | OpenAI | Copilots | Teams | Cloud Computing Solutions

6 年

Do you reminder how hard it was it the past to make timed job to SP. Hunderds hours in design, code, test and deployment.

要查看或添加评论,请登录

Michel Mendes的更多文章

社区洞察

其他会员也浏览了