Need to trigger notification every business day once the Business elapsed percentage field crosses 1

[Reddymahesh]

I have created custom percentage field on change_request table similar to business elapsed percentage on task_sla table. Using BR I am populating this custom field to be in sync with business elapsed percentage field on task_sla table. Once this custom field crosses 100% I need to trigger notification once on each business day end. Any ideas how to achieve this.

I am also facing issue that custom field not getting updated after 100%  even though OOB field on task_sla is getting updated.

[Uncle Rob]

If you just sent the message when the field hits 100%, why do you also need to ensure it only happens once per day?
Is there a mechanism for the field to reduce its %?

[Reddymahesh]

@Uncle Rob Its an requirement we need to send notification for each business day after 100% reached 

[Uncle Rob]

So why not flip to just the schedule condition?
Once / day, loop through all 100% records, and generate notification events.
(or have flow do it and you can send the notifications directly and skip the event part)

[Sohail Khilji]

Hi ,

Here is my understanding,

I guess you wanted to send notifications once a day for on the current date which records have breached 100% ? If yes.

Then create a scheduled job that glides all the records that reaches 100% on current date (today's date) and send notifications via event. 

Iterate with all records that meets that condition and trigger event to send notification.