Skip to main content

Notifications

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

Power Automate for custom table.

Posted on by 190

Hi, I've a custom table called myTask in Business Central and want to trigger a event when any change in this table.

Trying to use "When a record is Changed V3" in Power Automate, but nothing will be triggered when I change a record.

Is some way that I can trigger a event in Power Automate for a custom table? If not, can I use "Get a Record" in Power Automate to get records from custom tables?

2022_2D00_02_2D00_05_5F00_23_2D00_22_2D00_01.jpg

  • NithinkReddy Profile Picture
    NithinkReddy 10 on at
    RE: Power Automate for custom table.

    I have a table call vendor bank statement but for some reason when i use trigger when the row is modified, created, deleted. i am not able  to see that table under the api, but I have added that to the API. However, when i use get records action and enter the api there i can see the vendor bank statement there. Am i missing something here. please let me know 

  • Gianfranco C. Profile Picture
    Gianfranco C. 370 on at
    RE: Power Automate for custom table.

    hello, have you solved? I also tried to use the connector with custom table and new page api. The triggers see the new table and page, but the trigger does not appear to be intercepting anything.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,110 Super User 2024 Season 2 on at
    RE: Power Automate for custom table.

    Hi, Just creating a table is not enough, you should create a new API page.

    For example:

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

    pastedimage1644193466952v1.png

    There is a similar example in the following post.

    https://yzhums.com/20111/

    Hope this will help.

    Thanks.

    ZHU

  • Ming Chen Profile Picture
    Ming Chen 190 on at
    RE: Power Automate for custom table.

    Hi Josh,

    Thanks for reply. In my case, the table is "myTask" which is a custom table (not a standard table + custom page). In this case seems it won't be triggered.

    I also tried the "Find Records V3" but cannot use my custom table as an table name.

    2022_2D00_02_2D00_06_5F00_17_2D00_08_2D00_14.jpg

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Power Automate for custom table.

    For a custom API page on a standard table it still seems to trigger. Tested it with on for the opportunity table. Task wise there is a standard table already for user based tasks. Perhaps a custom api page on that could be a fit for you.

    Given you’re developing this you could try this concept: joshanglesea.wordpress.com/.../

    For getting records use the “Find records” so you can grab all of them instead just one

  • Damjan Zakojc Profile Picture
    Damjan Zakojc 431 on at
    RE: Power Automate for custom table.

    Hi, 

    You have to expose table as an APIpage and add that page in the Web Service setup in the BC. 

    First, design a new page and set the page type to APIpage, then expose that page in the web service in the BC. 

    Then, you should see that table in the Power Automate flow under the available tables.

    Thanks Damjan

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,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans