
My requirement is to update selected records bulk records only if hours =8, otherwise throw error message that one or more records in the collection doesn't match criteria.
For this my code for onselect property of submit button
ForAll(
colselected,
If(
Sum(
Filter(
'TimeEntries',
TE.Value = ThisRecord.Title
),
Duration
) = 8,
Notify(
"This record " & ThisRecord.Title & " have 8 working hours",
NotificationType.Success,
3000
),
Notify(
"This record " & ThisRecord.Title & " does not have 8 working hours",
NotificationType.Error,
3000
)
)
)
but it is always displaying error message even If I select the record with 8 hours also.
Hi @Rama130 ,
Could you please share more details about your scenario? What's the relationship of the collection and the TimeEntries table? What is the Items property of the Gallery?
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.