cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kinghnvn
Post Patron
Post Patron

Expression: less than 20 minute

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

kinghnvn_0-1638029588332.png

 

Flow

kinghnvn_1-1638029862432.png

 

 

All help is appreciated.

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

Use this for the right side of your condition.

addMinutes(utcNow(),20)


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

Use this for the right side of your condition.

addMinutes(utcNow(),20)


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 

 

Yes, I have tried but it's not working, please find below error

 

kinghnvn_0-1638064258457.png

 

My flows:

 

kinghnvn_1-1638064292956.png

 

My columns in SharePoint list

kinghnvn_2-1638064338364.png

 

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,145)