When updating sysapproval_approver state field to 'approved' via business rule, flow does not see it and does not go to if approved action

Igor Tsalyuk
Kilo Guru

When requesting a catalog item that requires approval, I need to check if Approver has a VIP flag, then I can auto-approve the request and proceed to create a task for an appropriate group.

I have a flow that is looking for approval for the requested_for.manager.

I created a business rule on sysapproval_approver table on Insert and Update that if the approver has VIP flag set to true, then set state field to 'approved'. But when Business rule is getting triggered, then I can see that the approval field is set to approved,but for some reason I see 2 approval records and both of them approved, but the flow behind the process is not recognizing this as 'Approved' and waiting for approval. Any idea what am I doing wrong?

find_real_file.png

find_real_file.png

 

11 REPLIES 11

Prasad Pagar
Mega Sage

Hi @Igor Tsalyuk 

Any specific reason you are setting up the approval using BR? Why not directly from Flow Designer?

Thank you
Prasad

Igor Tsalyuk
Kilo Guru

The problem is that I have dozens of catalog items. I did not want to go and modify each of them to accommodate VIP approvers. Was hoping that I can do it in one business rule and keep all the flows unchanged.

Prasad Pagar
Mega Sage

Ok with BR it should work. Can you please show me your wait for condition action on flow?

Igor Tsalyuk
Kilo Guru

Here is Ask for Approval:

find_real_file.png

 

And here is If approved condition:

find_real_file.png