Skip to main content

Notifications

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

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

Posted on by 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:
  • jensmurer Profile Picture
    jensmurer 7 on at
    Power Automate "Could not retrieve values" error with Business Central Actions' API Categories
  • Tom Profile Picture
    Tom 4 on at
    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 Profile Picture
    Magicrevette 215 on at
    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 Profile Picture
    YUN ZHU 73,333 Super User 2024 Season 2 on at
    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

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans