Power Platform Community Forum Thread Details

Hi Team,

I am facing a challenge where I am calculating the time difference from a field where the requirement:

"Second row start time is first row end time" So calculation is working fine as per requirement but the problem is I am also filtering the data from the data source.

Now in filter data I want to add row so there "hh:mm" set as "00:00" (Bases on logic), here I need to calculate the time.

Sharing the snapshot for better understanding.

Based on this image when I am coming after saving data and filter data need to add row then facing problem.

Logic based on fields sharing here:

1-Time field code is:
Text(Time(0,DateDiff(LookUp(colactivrreport,RID=ThisItem.RID).Starttime,LookUp(colactivrreport,RID=ThisItem.RID+1).Starttime,TimeUnit.Minutes),0),"hh:mm")

Getting difference as 07:30 - 7:00 = 00:30

In the last getting 00:00

2- Starttime Code:Default

If(!IsBlank(Filter(colactivrreport,'Project Number'=drpProjectID.Selected.Value && DateValue( Today_Date)= embarkdate_1.SelectedDate)),
ThisItem.Start_Time,ThisItem.Starttime)

3- Add Row Code:

If(IsBlank(drpProjectID.Selected.Value),Notify("Please select project id",NotificationType.Error),Collect(colactivrreport,{Starttime:"",RID:CountRows(colactivrreport)+1}););

Note:

Here I want the logic where to calculate the time in last when coming from filter data.