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

Power Automate "Could not retrieve values" error with Business Central Actions' API Categories

(0) Share

Report

Posted on by Magicrevette

215

Hello,

I created a very simple flow on Power Automate SaaS yesterday.

The goal is to create a new record in a custom table when a sales order is released (it's for testing) on the same tenant on Business Central SaaS. It worked perfectly.

This morning, I can't see any API categories (custom or Microsoft's) in this flow or in any other new flow, in this environment or in any other. Instead, I have this error :

I've tried to enter a custom value. I have another error instead :

Do you know what is the problem and how to solve it ?

I've already encountered this issue last week. It resolved itslef the next day, it's a bit worrying...

Thank you

Categories:

Business Central

All responses (4)

Answers (0)

jensmurer 7 on at

Like (1)

Report

Power Automate "Could not retrieve values" error with Business Central Actions' API Categories

Hi,

the same issue is dicussed in the power automate community:
https://powerusers.microsoft.com/t5/Building-Flows/Business-Central-Get-Record-V3-error-to-API-Category-Could-not/m-p/2345246/thread-id/260832
Tom 4 on at

Like (1)

Report

Power Automate "Could not retrieve values" error with Business Central Actions' API Categories

The same issue started to appear here. You can select the “Environment” and the “Company” from the dropdowns but it does give an error on the “API Category”. If I start a new flow it fails directly to.

The error it does give:
Could not retrieve values. The dynamic invocation request failed with error: { "Message": "No HTTP resource was found that matches the request URI 'https://dynamicssmbsaas-ne.azconn-ne-002.p.azurewebsites.net/v3/bcenvironments/EU-NL-PROD/companies/******************/datasets'.\r\nclientRequestId: 01c67605-b918-4a82-9291-7e8eb250bda9" }.

When you add the V2.0 to the "API Category" is shows the list of the "Tables" but it does not load the items and when you try to save it fails as mention.

Existing scripts keep running but you cannot change any thing anymore due to the API issue.
Magicrevette 215 on at

Like (1)

Report

Power Automate "Could not retrieve values" error with Business Central Actions' API Categories

Thanks fo your answer Zhu. The probleme always appears the day after I created my flows. Never the same day.

Now it has been two days since I've created my flow, and it worked again... I don't understand...

edit : I think Microsoft did an update on Automate, because the interface is different compared to yesterday :

The Business Central logo connector changed.

And the parameter requiered for this action changed too.

It wasn't plannified or announced. It was the same situation last week when they changed the menu on the left...
Suggested answer

YUN ZHU 73,333 Super User 2024 Season 2 on at

Like (0)

Report

Power Automate "Could not retrieve values" error with Business Central Actions' API Categories

Hi, I tested it and didn't encounter your problem.

I suspect that the company name was not found.

For example,

Hope this can give you some hints.

Thanks.
ZHU