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)

Sort by

JasonLane 261 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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