Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Date and time Validation

(0) ShareShare
ReportReport
Posted on by 93

Hi Everyone

 

Please note that I have a list for managing overtime that contains the following columns

 

- Employee Number

- Employee Name

- Date

- Time from 

- Time To 

- Total

 

I need that when a user create new item for any employee number to check if this new item intersect with other records for the same employee number and give message that this item intersect with other items for the same employee number

example:

 

suppose that I have the below saved records

Employee NumberEmployee NameDateTime FromTime ToTotal
100Rami20-10-2018:0022:004

 

and the user try to create the below item

 

Employee NumberEmployee NameDateTime FromTime ToTotal
100Rami20-10-2021:0022:001

 

so, I need to prevent the user to add this record and show him/her message that this record intersect for another records as the new record is for the same employee in the same date and the new time is from 21:00 to 22:00 while he has another item in the same date from 18:00 to 22:00.

 

otherwise, if their is NO intersection the item should be accepted 

 

e.g if the user try to create the below item this should be accepted 

 

Employee NumberEmployee NameDateTime FromTime ToTotal
100Rami20-10-2014:0016:002

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard