Unanswered

Email on List Item inactivity?

(0) Share

Report

Posted on by Community Power Pla...

So I have a SharePoint list with multiple Flows on items creation and modification, all of which are working smoothly. It has been requested of me to create a few "reminder" emails when any list items have not seen any activity for a certain amount of time.

For example, one column in the list is called Priority, and if Priority is Low trigger an email on 5 days of no activity. If it's High, on 2 days of no activity, etc.

I realize Flows require a trigger, but I am hoping maybe in these cases the base trigger could be the time. For example, at midnight the Flow scans for list entries that meet the criteria and generate an email.

Is this possible? I've found nothing so far in my searches, so I am growing more skeptical.

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Email on List Item inactivity?

I have to say that in 37 years of engineering work and programming in dozens of languages, ODATA is the most non-intuitive, obtuse language I have come across yet (maybe Siemens' early "S" languages come close). How does "It" mean "less than"? (Sorry, just ranting from frustration that I have to learn yet another language just for this one project).

I am having enormous difficulty pulling values from a column, using a constant, etc. and am getting very little progress on this. Maybe I should take a step back and ask if there is a good reference document you can point me to in building phrases as it relates to a Flow? How do I retrieve a column's value? How do I use a constant? How do I....

Not really asking you these Qs, more like just looking for a basic reference for how to make statements, get data, etc.
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Email on List Item inactivity?

@Anonymous:

Here is an example that may help.

The Flow below uses a Get Items action and uses an ODATA filter to retrieve only items that were modified 5 days ago.

The HTML table action is just so I can see my results.

The ODATA expresseion says that I only want items that were modified on or after the current date less 5 days and itmes modified before todays date less 4 days.

In ODATA filter, ge means greater than or equal to and lt means less than.

I used a Button trigger for test purposes - you'll want to use a Recurrence trigger.

In addition, it sounds like you'll need some additional logic.

If this addresses your issue, please mark you post as Solved.
Community Power Pla... on at

Like (0)

Report

Re: Email on List Item inactivity?

Thanks! This definitely appears to be what I am looking for, but I am as new to ODATA as can be (just heard of it in your response above). I reviewed the example you linked to but am struggling to put together an expression that checks the entry of a variable, and then computer the time difference and takes action based on this.

If you can think of a post closer to what I am trying to do can you send me a link to that?
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Email on List Item inactivity?

@Daryl_K:

To accomplish your goal, you'll want to use a recurrence trigger. You can set the trigger to fire every day, every hour, etc. .

When the trigger fires, use a SharePoint Get Items action to retrieve the list items. I suggest using an ODATA filter and select only those entries which have not been updated within the time period that you specify. You'll need to do some date calculations here using Date and Time expressions.

Loop through each of the items returned and send emails as appropriate.

Here is a link to a post that discusses using ODATA date filters.

If you need a better example, please let me know.

If this addresses your issue, please mark your post as Solved.

Scott