i am trying to record the date time when record appears in left view and when it goes to right view. view has criteria but that criteria can't set in SLA Applicable step.
i am positive and hoping you guys will help me out or is there nay other workaround will be appreciated guys
Thanks Leo i am calling this flow after 2 second i have some concern
Each call after = 2 second = 1 call
In One minute = 60/2 = 30 calls
in One hour = 30*60 = 1800 calls
in One day = 1800*24 = 43200 calls
is there any other way in which i can achieve this without lot of calls?
Hi partner,
Thanks for your recognition :-)
Please feel free to let us know if you have any other questions in this thread.
Regards,
Leo
Thanks Leo Partner
i am marking this as verified cause you guys really spent your time
Hopefully this will work
Hi partner,
SLA condition does not support customization.
You could use Power Automate(FLOW) to do this.
For example you want to save the date and time when record fulfill the view criteria, you could create a scheduled flow and let it run per minute or even per second.
And then we create a "List records" action which will show all records which fulfill your custom condition.
So you could copy the view criteria to the filter line with condition statements.
like appointment is yesterday, we could use "UTCnow()" to get current date and time, use "AddDays(UTCnow(),-1)" to mean yesterday.
And when we find out these records, we should store the date and time to a field, so we create a update action, select the entity and instance, and then set the current date time "UTCnow()" to the field to record the time.
In this way, this flow will run per minute or second and if it find any record which fulfill the condition, it will store the date and time to a special datetime field on your form you've created before.
Best Regards,
Leo
Thanks Leo
but it not like that i am looking for a solution when any record fulfill the view criteria then i want to save its date and time.
i don't want to do this job manually.
can we change the SLA Applicable condition on which it revoke itself this way i can add yesterday condition because OOB is not providing the yesterday option on date fields
Hi partner,
Workflow, plug-in or other actions all need a trigger condition like when creating/updating/deleting/assigning...record.
In your case, you need to collect the date of records and the condition is that "Appointment Date" is yesterday. I recommend you to create a on-demond workflow, and you need to run it everyday manually.
You could use this condition.
Best Regards,
Leo
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156