Delete items within a certain time in sharepoint

(0) Share

Report

Posted on by birms93

Hi all,

I have problem that I am trying to figure out.

I have had a look at the forums but can't find exactly how to do this - all the examples I have seen are to do with dates rather than time.

The problem:

I have column in SharePoint called 'Check Out From' which is a date and time field and a field called CheckedIn (Yes/No).

If the user hasn't checked in (CheckedIn = false) within 30 minutes after the Check Out From. Then I want to delete the list item.

I am trying to work out what the condition for the above would be?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

JasonLane 261 on at

Like (0)

Report

@birms93 Have you got the date/time field separate in the SP Form? I believe its the
addToTime(utcNow(),-30,'hh:mm') or it could be
addMinutes(utcNow(),-30,'mm')

If you have the time separate and then the same approve as another condition for date to say . I dont have the flow you have created so cannot be 100% but this may help you.
Please accept if this has helped.

Was this reply helpful? Yes No
birms93 2 on at

Like (0)

Report

Hi,

So my flow looks like this:

The condition bit is what I need help on.
The SharePoint column follows the following format:
If in the above example the user hasn't checked in by 8:30AM on 10/4/2022 then I want to delete the row. I don't want the condition to delete any other rows on that day. It should compare the time now with the time in SP +30 mins and if over, then delete row. If that makes sense.

Was this reply helpful? Yes No
JasonLane 261 on at

Like (0)

Report

hi,
So does this flow occur every morning and look for the time? Just need to understand how the trigger works?
I believe you still need to add the condition mentioned above. There is a few articles when searching about the conditions mentioned in my last post that may assist you as well. couple below:
https://manueltgomes.com/reference/powerautomate-function-reference/flow-addminutes-function/
https://softchief.com/2021/09/13/use-of-date-time-expressions-guide-for-power-automate-complete-tutorial/
Let me know.
Thanks

Was this reply helpful? Yes No