Hi,
I have a SharePoint list, within this list I have the following columns: CheckIn (text) and StartTime (date), I would like to be able to create a flow looks for a date within the StartTime column which is lest than 20 minutes now and delete the list item.
SharePoint list
Flow
All help is appreciated.
Thanks.
Solved! Go to Solution.
Use this for the right side of your condition.
addMinutes(utcNow(),20)
Use this for the right side of your condition.
addMinutes(utcNow(),20)
Yes, I have tried but it's not working, please find below error
My flows:
My columns in SharePoint list
The problem is caused by having null entries for the Start time. Add a row in your condition before the greater comparison that checks to see if the start time is null. If that is false then the whole condition will be false without checking against the 20 minutes.
User | Count |
---|---|
95 | |
45 | |
21 | |
18 | |
18 |
User | Count |
---|---|
142 | |
50 | |
43 | |
40 | |
31 |