Answered

Count duration with DateDiff and Cds / Dataverse

(0) Share

Report

Posted on by BayuChoirul

Hi, I am new Power Apps user. I need help to fix this.

I a create powerapps with cds/dataverse for employee check in and check out. in button check out, i want count duration with datediff. but, i get problem with "Invalid argument type" in button check out. My code in check out like this.

Patch(
 'Time Entries',
 LookUp(
 'Time Entries',
 'Time Entries'.Start = GalleryTimeEntries.Selected
 ),
 {
 'Bookable Resource': GalleryResource.Selected,
 'Work Order Service Task': GalleryServices.Selected,
 End : Now(),
 Duration: DateDiff(
 LookUp(
 'Time Entries',
 'Time Entries'.Start = GalleryTimeEntries.Selected
 ).Start,
 Now(),
 Minutes
 )
 }
 )

Screenshot (4).png Screenshot (6).png

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

WarrenBelz 154,426 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @BayuChoirul ,

The fundamental problem is that .Selected returns a record and you are trying to match it with a Value. Without seeing your model, data and required outcome, this may not be correct, but the syntax maybe should be something like this. Note you will need to include the field that is unique to the record (to identify which record to Patch)

With( {wTime:GalleryTimeEntries.Selected}, Patch( 'Time Entries', {IDField:wTime.IDField}, { 'Bookable Resource': GalleryResource.Selected, 'Work Order Service Task': GalleryServices.Selected, End : Now(), Duration: DateDiff( wTime.Start, Now(), Minutes ) } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BayuChoirul on at

Like (0)

Report
Copy link

Link copied!

thanks for your help. may i ask a questions again. Formula has been solve, but i get new problem. that is "msdyn_start : field mysdn_start required". location in button check out

Was this reply helpful? Yes No
WarrenBelz 154,426 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @BayuChoirul ,

This is a bit of a guess, but does this work

With( {wTime:GalleryTimeEntries.Selected}, Patch( 'Time Entries', {IDField:wTime.IDField}, { 'Bookable Resource': GalleryResource.Selected, 'Work Order Service Task': GalleryServices.Selected, Start: wTime.Start, End : Now(), Duration: DateDiff( wTime.Start, Now(), Minutes ) } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BayuChoirul on at

Like (0)

Report
Copy link

Link copied!

thanks for your help. but, formula still not counting duration.

Was this reply helpful? Yes No
WarrenBelz 154,426 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@BayuChoirul ,

If you put this in a label, do you see the Start value?

GalleryTimeEntries.Selected.Start

If not you need to find out where this value is so the calculation can be done.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BayuChoirul on at

Like (0)

Report
Copy link

Link copied!

thank you warren, duration can be calculated

Was this reply helpful? Yes No