2
Hi all,
I am using a sharepoint list to track sales opportunities. I would like to create a flow to do a couple of things:
Situation
The list item has not been modified for 30 days.
Desired Flow
I am by no means an expert here so any guidance would be greatly appreciated!
Thanks!
I don't know what your process is, but if you have a status column, you could use that in the filter. So you only get items that are in the status before Stalled.
To really zero in on items you want, you could have a Status column and then a StatusDate column.
So whenever your flows are changing the Status to something, also update the datetime in the StatusDate column.
Then you don't have to check the modified date, you would check the status date.
@wskinnermctc Thank you so much! I so appreciate you and your willingness to help.
You bring up a great point. I will start with this to see if i can get it to function. will also think about perhaps a better way to gauge a true stall to the pipeline.
This is an easy thing to set up. But I want to ask about using the "Modified" datetime as a way to identify the stalled items.
The reason is because the "Modified" time will change if someone goes in an edits a name or any other field, but that doesn't necessarily mean they acted on the object as you expected.
Do you have your process set up so that you know for sure that "Modified" is the best field to use?
I'm not questioning you or saying it is wrong, just double checking.
Here is a basic example of what your flow should look like. You need to put an expression in the Get Items - Filter Query field that is checking the Modified column to only return items that have a modified datetime that hasn't changed in 30 days.
Share
Report
All responses (
Answers (
Modified le 'addDays(startOfDay(utcNow()),int(-30))'Here is a photo of the flow: (This was made in the editor Designer Classic View)
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
