Answered

Help with dates and times differences

(0) Share

Report

Posted on by Brammers

Hi All, hoping some genius can help me see a way to acheive this -

I'm building an Equipment Request PowerApp (for things like iPads etc) so staff can request an item, and we can keep track of it.

I can easily book the item out, but what I can't seem to do is then stop someone else creating another request for the same item at the same time.

Any ideas?

I've tried adding a gallery with all the existing bookings, and then filtering by item, start date/time, end date/time, and then using CountRows to return an error if anything is 'found' - this only work if the times are the same, or fall within the start / end times. It doesn't 'find' the existing booking if the new start date/time is BEFORE the existing start date/time, and the new end date/time is AFTER the existing booking end date/time (sorry if i'm not making that very clear). Maybe someone can help me out with this method?

Alternatively, is there a way of getting a unique list of values (minutes) between two dates/times? If I can do that, then I can do a simple comparison between the existing list, and the 'new' list for any matches.

Or alternatively again - does anyone have a completely different way to acheive this? Happy to try different methods!!!

Thank you all in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Pstork1 69,647 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a check in process when a user brings it back? Maybe just add a field to the equipment record for Checked Out. The only problem I see is making sure to uncheck it when its returned.

Was this reply helpful? Yes No
Verified answer

Brammers 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, there will be a check in / out process as part of the app, but this issue is to do with stopping multiple bookings.

I've been playing around for an hour, and I think i've cracked it too.... Yay!

I've continued with the filtered Gallery method, and using the following 'rules' - it seems to work as I expected!

Filter(
Sort(
'IT RequestsV2',
Code,
Ascending
),
CodeN1_Value.Text = Code && (('Start Date TimeN1'.Update >= 'Start Date Time' && 'Start Date TimeN1'.Update <= 'End Date Time') || ('End Date TimeN1'.Update >= 'Start Date Time' && 'End Date TimeN1'.Update <= 'End Date Time') || ('Start Date TimeN1'.Update <= 'Start Date Time' && 'End Date TimeN1'.Update >= 'End Date Time'))
)

Was this reply helpful? Yes No
Pstork1 69,647 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Glad you found your answer.

Was this reply helpful? Yes No