web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Business Central table names for Microsoft Flow interaction

(0) ShareShare
ReportReport
Posted on by 10

Hi,

I've been trying to use Microsoft Flow to automate some things between Business Central and Outlook here in our company. With the available tables, I'v been succesfully able to do what I want, but using another Table.

Here's the deal : Microsoft Flow gives me a choice of only 10 Tables to chose from (while creating a trigger), with an option to enter a custom value ( And there are WAY MORE than 10 table in Business Cental ): 

pastedimage1565113623824v1.png

Let's say I try to automate things with the items table (either with outlook, some PowerApp, etc), everything works as expected and I'm able to read/write items in the required Business Central company.

That being said, the problem here is that I'm not able to use other Tables / I don't have required table names. Even though I am able to interact with the items table, I actually want to interact with jobs within Business Central. I tried to type "job", "jobs" and others similar as a custom value, but Microsoft Flow will only give me a "NowFound" error.

Here's an exemble I tried, with "jobPlanningLines" as custom value. 

{
"status"404,
"message""Entity set not found: jobPlanningLines\r\nclientRequestId: f01099c0-0ee2-4235-ae09-780b1e9df482",
"source""dynamicssmbsaas-ce.azconn-ce.p.azurewebsites.net"
}
So, is there a specific way to have acces (within Microsoft Flow) to other Business Central tables other than the 10 already listed. If so, what would be the real names of those table (so I could use them as "custom value")?
Thank you very much!
Categories:
I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    37,172 Most Valuable Professional on at

    You cannot see all tables, but only tables that are exposed as APIs. Flow connectors uses APIs, I don’t know if it can see all standard exposed APIs or only a subset.

    From MS Flow you can also call REST APIs by using the Http action, so you can use that action + Parse JSON in order to use your custom APIs exposed by D365BC or your custom OData endpoint.

    For example, if you need Job Planning Line you can (alternatively) create a custom API with AL or simply exposes the Job Planning Line page as OData web service and use that service from Flow.

  • Suggested answer
    Olister Rumao Profile Picture
    4,009 on at

    Hi Charles,

    There are only standard set of Tables supported Out-Of-Box in MS Flow.

    You can do this by entering the page in WebServices and call this webservice using HTTP Request.

    Refer: www.olisterr.tech/.../how-to-use-rss-feeds-ms-flow-microsoft.html

    In this blog I have added as to how you can do the integration for custom tables.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans