Small and medium business | Business Central, N...

Power Automate request approval for purchase quote seek the requestor's manager for approval

(1) Share

Report

Posted on by MT-13090547-0

Scenario:

Currently, I'm using the Business Central Purchase Quote workflow process and have configured a Power Automate workflow based on the template "Request approval for Business Central purchase quote (first response)". This workflow functions correctly when approvers have unlimited approval limits.

However, during testing with various purchase quote amounts, I found that the first approver with an approval limit of $5,000 was able to approve a purchase quote of $20,000. This indicates that the approval limits defined in the Approval User table (located in User Setup (91)) are not being recognized or utilized by the existing Power Automate workflow.

What I want to achieve is to have the Power Automate workflow dynamically pick up these approval limits and route each purchase quote through the appropriate workflow channel. This way, each approver would only be able to approve purchase quotes that fall within their specific limit. Currently, the existing template workflow doesn't support this feature.

Any guidance on how to configure the Power Automate workflow to correctly utilize the approval limits would be greatly appreciated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report
Configure Business Central to Expose Approval Limits table(API)

Ensure that the Approval User Setup table (table ID 91) is available for Power Automate:

Retrieve Approval Limits:

Use the Business Central connector in Power Automate to fetch data from the new API page.

Filter the list of approvers to include only those whose limits are greater than or equal to the purchase quote amount.

Example action:

HTTP Get or List Records to fetch approvalUsers.

Apply a filter: Approval Limit (LCY) >= Purchase Quote Amount.

Please mark the answer as verified if it helped resolve your question.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (0)

Report

I checked the standard code and didn't find any approval limit control. I'm not sure if you used the Get direct approver step, it would be very helpful if you could provide a screenshot.

codeunit 1543 "Workflow Webhook Management"

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
MT-13090547-0 17 on at

Like (0)

Report

Yun Zhu, yes I am using the Get Approver step in the workflow. I am using the template workflow. Which doesn't have the user approval table available to select the approval user and their limits.

Was this reply helpful? Yes No
MT-13090547-0 17 on at

Like (0)

Report

Hi Ramesh,

I was able to expose the User Approval table to Power Automate.

What are the next workflow actions in being able to see the approval limits of the approvers?

Thank you

Was this reply helpful? Yes No