Task need to be generated if no approver details present in the table

[suuriya]

Hi Community,

I have a requirement, there is table (approver table) and in that table 2 fields environment name and approver....in workflow if there is no approver/missing/approver is inactive for any of the record in the table then task need to be generated to x team....how can we achieve this

Can you let me know how to check if approver is present in the table or not 

Thanks in advance

[Mark Manders]

Are you using a workflow, or a flow? It would be an easy thing to do in the flow: just lookup the table and validate, before creating the approval itself. You can just create a task from there (look up records where approver is missing or inactive -> if success -> create task -> else -> create approval). Or the other way around of course.

[suuriya]

HI @Mark Manders ,

I need this in workflow and not in flow designer....can you please let me know how we can achieve this in workflow

[Mark Manders]

You can put a script step in your workflow, validating first on your users, before it goes further and then create a task if no users are found. But that will be the end of your workflow, since you can't proceed without valid approvers?

[Dr Atul G- LNG]

Hi @suuriya 

You need to check like

You can get the catalog variables via Action and then check

If Variable.Value is empty or value= caller and caller. active = False

Then

Create Task.