Restrict submit button when user enter morethan 8 hours per day.

[Powerappsdev2]

Hi  Community Team,

I want to restrict user  if user enter >8 hours/day.

I'm using below code it is working  for  gallery row wise but select bulk records in that time this code not working. please help me to achieve this requirement.

If(Sum(Filter(Trainelist,Date=DatePicker6_18.SelectedDate,Email=User().Email),Hour)+Value('hour TextInput7_21'.Text)>8,DisplayMode.Disabled,DisplayMode.Edit)

Below image when user enter working hours in bulk ,these are >8 also data saved in sharepoint list. my requirement is if it's grater than 8 hours the button to disabled.

Gallery--data source --collection  (Addrecords)

these records are saved in sharepoint list.

DisplayMode of submit button=

Trainelist=sharepoint list

If(Sum(Filter(Trainelist,Date=DatePicker6_18.SelectedDate,Email=User().Email),Hour)+Value('hour TextInput7_21'.Text)>8,DisplayMode.Disabled,DisplayMode.Edit)

Please help

Thanks in advance for quick response....!!!

[SpongYe]

@Powerappsdev2 

I have recreated your problem in a simple app.

This example is of yesterday (29/08/2023) and the user has already reached the maximum:

This example is in future (31/08/2023) and the user can't add a record with 9 hours. 

But can we 8 hours:

This example is of today (30/08/2023) and there are is 1 hour left register:

I can still register 1 hour so the button is enabled/ in Edit mode. 

I cant register 2 hours for today otherwise the button is disabled.

My code is as following Button1.DisplayMode:

If(
    Sum(
        Filter(
            Trainelist,
            Date = DatePicker1.SelectedDate, 
            Email = User().Email
    ),
    Hour
    ) + Value(TextInput1.Text) > 8,
    DisplayMode.Disabled,
    DisplayMode.Edit
)

Added a screenshot of the code:

I hope this will help you to let yours worked.

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

[Powerappsdev2]

Hi @SpongYe 

Thanks for your valuable information.

   Your given code will helpful for after submitting 8hours per a day.but when user enter working hours like below also data stored in share point list but as per requirement disabled the submit button.

Date:31-08-2023 Working Hours:06

Date:31-08-2023 Working Hours:01

Date:31-08-2023 Working Hours:02

Gallery --Datsource =collection(addnewrecors)

Please help for above scenario

Thanks in advance for quick response....!!!

[SpongYe · Accepted solution]

I have seen your new topic and will look into this as well.

If I have answered your  initial question, please mark your post as Solved. 
If you like my response, please give it a Thumbs Up.

[Powerappsdev2]

Hi @SpongYe 

Please help for new topic scenario

awaiting for solution.

Thanks for support...!!!