Power automates flow for Purchase Document using specific approver

(9) Share

Report

Posted on by Mahek Mehta

145

To implement the logic, you’re describing — where in your Power Automate flow (triggered by “When a purchase document approval is requested”), you want to:

Check if the assigned approver is correct Specific Approver Email id or not, if not Cancel the approval request, and send a new approval to the correct approver email id. So, I have created this flow for achieving it. Can this be possible to create.
I am facing an issue: Flow save failed with code 'MultipleErrorsOccurred' and message 'The dynamic operation request to API 'dynamicssmbsaas' operation 'GetTableV3' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Entityset 'approvalEntries' cannot be found.\r\nclientRequestId: 0f5dd137-b258-4626-803c-277c049135f9", "error": { "message": "Entityset 'approvalEntries' cannot be found." }, "source": "dynamicssmbsaas-si.azconn-si-001.p.azurewebsites.net" };The dynamic operation request to API 'dynamicssmbsaas' operation 'GetTableV3' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Entityset 'userSetupsApi' cannot be found.\r\nclientRequestId: 0f5dd137-b258-4626-803c-277c049135f9", "error": { "message": "Entityset 'userSetupsApi' cannot be found." }, "source": "dynamicssmbsaas-si.azconn-si-001.p.azurewebsites.net" }'.
Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'dynamicssmbsaas' operation 'GetTableV3' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Entityset 'approvalEntries' cannot be found.\r\nclientRequestId: 95090f4b-b976-4da9-b8dd-fae9bb21ebd3", "error": { "message": "Entityset 'approvalEntries' cannot be found." }, "source": "dynamicssmbsaas-si.azconn-si-001.p.azurewebsites.net" }

Categories:

Dynamics 365 Business Central migration

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (4)

Report

maybe this will give you a hint to resolve your problem

https://learn.microsoft.com/en-us/power-automate/modern-approvals?tabs=new-designer

https://learn.microsoft.com/en-us/power-automate/approvals-howto

https://community.dynamics.com/forums/thread/details/?threadid=d231650e-e413-4811-beec-9a692ddec101

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,188 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

Could you please indicate what type of permit you have and licensing?

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi

Verify that this userSetupsApi name is appropriate for the Ws or API you are working with.

Best

GR

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (2)

Report
Hi MM,

The error you're encountering is tied to how Power Automate interacts with BC’s API layer, especially when referencing system tables like approvalEntries or userSetupsApi.

Why the Error Occurs

The error message: "Entityset 'approvalEntries' cannot be found."

indicates that Power Automate is trying to access an entity that does not exist in the standard API v2.0 schema or is not exposed via the connector.

Similarly, userSetupsApi is not a standard entityset — it may be a custom API page or an internal object not exposed to external connectors.

This typically happens when:

The flow references a table that isn’t published as a web service

The environment type or company context isn’t correctly passed

The connector is misconfigured or lacks permissions

Recommended Fixes

Option 1: Use Standard API Entities

Instead of approvalEntries, use the Workflow Event Response or Approval Request Entries if available via standard API or custom page

Option 2: Publish Custom API Pages

If you need access to approvalEntries, create a custom API page in AL and publish it via Web Services.

Example:
al page 50100 "Approval Entries API" { PageType = API; SourceTable = "Approval Entry"; EntityName = 'approvalEntry'; EntitySetName = 'approvalEntries'; ApplicationArea = All; UsageCategory = Lists; }

Once published, Power Automate can access it via OData or the connector.

Option 3: Validate Environment and Company Parameters

Ensure your flow includes:

EnvironmentName

CompanyName

These are required for non-tenant scoped requests. Missing them triggers the NotFound error.

Option 4: Use Power Automate HTTP Connector

If the standard connector fails, use the HTTP connector to call BC’s API directly.

Authenticate using OAuth2 and pass the correct headers and body payload.

Option 5: Test with Postman or VS Code

Before wiring into Power Automate, test the API call using Postman or AL extension to confirm the entityset is reachable.

Helpful References
Set up and use a purchase approval workflow – Microsoft Learn
Use BC in Power Automate Flows
Create Custom API Pages – Kauffmann Blog
Community Thread – Power Automate Entityset Error
Use approval workflows – Microsoft Learn

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report

You can see the output step by step. The error message indicates that dynamicssmbsaas, approvalEntries, and userSetupsApi are not found. Is this an issue with the ID?

In addition, you can directly use Microsoft's template and then modify it, which will save a lot of steps.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No