Need help to solve the issue in total working hours calculation in PowerApps

[B-Pooja]

I have two 'date picker' in power apps named as "Start date and time" and "End date and time" and have 1 'Break in mins' card which have the data type as "Number". The source data for this app is in SharePoint List. I created calculation for Total working Hours. Here I attached the Calculation,

Now my Query is, When I submit this form in PowerApps  the data is stored in SharePoint list but the PowerApps throws an error message like" The value ":" cannot be converted to a date or time value " How to resolve this issue in Power apps

[v-xiaochen-msft]

Hi @B-Pooja ,

I've made a test but did not encountered the problem you mentioned

Please try:

1\Set HourValue1/2 's Items property to :

ForAll(Sequence(24,0,1),Text(Value,"00"))

2\Set MinuteValue1/2's Items property to:

ForAll(Sequence(60,0,1),Text(Value,"00"))

And then check if the problem still exists

Best Regards,
Wearsky

[B-Pooja]

Hi Wearsky,
  I changed the hour and minute item property as you texted above but Still I have an issue in this app. I attached the image below. Thank you so much for your quick response.

Regards,
Pooja

[B-Pooja]

When I changed the item property in hour and minutes. The data doesn't stored in my SharePoint list. It remains blank. It stores only the break in mins and working hours alone.

[SanshubhLubal]

@B-Pooja  can you tell me about your SP list detail like column type.

[B-Pooja]

Start time : Date and Time column
End Time : Date and Time Column
Break in mins : Number
Working Hours : Single line of text. (I created calculation in Power apps that calculation result stores in this list)

[v-xiaochen-msft]

Hi @B-Pooja ,

Please check whether this formula can get any value

HourValue1.Selected.Value

Best Regards,

Wearsky

[B-Pooja]

Now the Start time and end time have successfully stored in my SharePoint List.
My only issue is, When I submit the form the data is successfully stored in my SharePoint list
But, Power apps throws an error message  "The value ":" cannot be converted into date or time value"
How to resolve this error message.

[B-Pooja]

Hi Wearsky,
                    This formula "HourValue1.Selected.Value" get value.
when the user select the hour value, the working hours calculation automatically triggered to calculate.

[v-xiaochen-msft]

Hi  @B-Pooja , 

Since "HourValue1.Selected.Value" can get the value, and the user can get the calculation result. How do errors occur? What did you do that caused the error? Is the "HourValue1" control in a Form? If it's in Form, I suggest you move them out of Form and try again.

Best Regards,

Wearsky