How we can call workflow/Action plugin/Plugin/Flow when record fulfills the view criteria

(0) Share

Report

Posted on by ZeeshanGhause

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

I have the same question (0)

All responses (6)

Answers (1)

LeoAlt 16,331 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

LeoAlt 16,331 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

Thanks Leo Partner

i am marking this as verified cause you guys really spent your time

Hopefully this will work

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

Thanks for your recognition :-)

Please feel free to let us know if you have any other questions in this thread.

Regards,

Leo

Was this reply helpful? Yes No
ZeeshanGhause on at

Like (0)

Report

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?

Was this reply helpful? Yes No