Power Platform Community Forum Thread Details

Hi everyone, I'm having some problems calculating the difference of hours between 2 drop downs depending on a co worker's department.
So I have a Sharepoint list called Equipa, where I have a lookup for the Department, and Department's List has a lookup for Horario.

I was able to calculate the hours only for a default Department, but i can´t find a way to calculate for other Departments with different schedules.

This is my code:

If(
 start_DataCard3.Update < end_DataCard3.Update && DateDiff(start_DataCard3.Update, end_DataCard3.Update, TimeUnit.Days) <= 30, 
 With({
 varHourRange: 
 AddColumns(
 ForAll(
 Sequence(
 DateDiff(
 start_DataCard3.Update,
 If(DataCardValue20.Value, 
 DateAdd(end_DataCard3.Update, 1, TimeUnit.Minutes),
 end_DataCard3.Update
 ),
 TimeUnit.Minutes
 )
 ),
 DateAdd(start_DataCard3.Update, Value -1, TimeUnit.Minutes)
 ),
 "Horas",
 (Hour(Value) + Minute(Value) / 60)
 ) 
 },
 CountIf(
 varHourRange,
 If(gblMotivoSelecionado = "Overtime",
 Or(
 Horas < gblHoraEntrada, 
 Horas >= gblHoraSaida, 
 Weekday(Value) in [1, 7], 
 Year(Value)*10000+Month(Value)*100+Day(Value) in colFeriados.DataInteiro
 ),
 And(
 Or(
 And(Horas >= gblHoraEntrada, Horas < gblHoraInicioAlmoco), 
 And(Horas >= gblHoraFimAlmoco, Horas < gblHoraSaida) 
 ),
 Weekday(Value) in [2, 3, 4, 5, 6], 
 Not(Year(Value)*10000+Month(Value)*100+Day(Value) in colFeriados.DataInteiro)
 )
 )
) / 60 / 8
 
 )
)

Thanks in advance for any help!

Categories:

Building Power Apps