I have fully customized purchase requestion process (Table Purchase req Lab, page also same), I added the API page and bring some fled to power automate.
My Query:
I need to create the approval workflow based on the department wise, department L1 and L2 manager should be approve this purchase request. (Approval matrix created in BC )
both parties approved purchase requestion status change to PR released otherwise show PR pending.
how i can achieve this, please suggest the solution.
To implement department-wise L1/L2 approvals for your custom Purchase Requisition in Business Central, the standard and recommended approach is to use Approval User Groups per department, where Sequence 1 = L1 manager and Sequence 2 = L2 manager, ensuring approvals happen in order and both are required. Then create workflows filtered by Department that request approval using the corresponding Approval User Group. Your PR status can be updated via workflow responses (Pending when sent, Released after final approval). If you want this fully dynamic using your own approval matrix table (instead of multiple workflows), that requires AL customization to create approval entries programmatically—but still using the standard approval engine. In short: multiple workflows + approval user groups = no-code standard solution, while matrix-driven logic = customization.
Regards,
Oussama Sabbouh
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
31
Share
Report
All responses (
Answers (
