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?
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
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.
Hi, Just creating a table is not enough, you should create a new API page.
For example:
There is a similar example in the following post.
Hope this will help.
Thanks.
ZHU
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156