Power Automate's Business Central Action "Create Record" doesn't work for my custom table

(1) Share

Report

Posted on by Magicrevette

215

Hello,

I use Business Central on Saas and Power Automate on the same Tenant. I've created a custom table (myTable) in an extension I have published on BC. On Power Automate, I would like to create a flow that uses the Business Central Action /Create Record (V3)/ to create a new record in my custome table myTable. But I don't know how to do it.

I tried to create an API type Page that has myTable as SourceTable, but I don't see myTable in the list of tables when I select my API.

edijson is the EntityName of my API type Page.

And here is myTable :

What am I missing please ?

Thank you for your help.

All responses (2)

Answers (1)

Magicrevette 215 on at

Like (1)

Report

Power Automate's Business Central Action "Create Record" doesn't work for my custom table

Hello,

Thank you for your answer Zhu. It helped me to solve my problem.
Verified answer

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

Like (0)

Report

Power Automate's Business Central Action "Create Record" doesn't work for my custom table

Hi, There is no problem with your approach, create a table -> create an API page, and then you can select your API page in the Power Automate (edijson).

Please note that what can be selected in Power Automate is only the API page, not the direct table.

Hope the following information can give you some hints.

https://yzhums.com/37458/

https://yzhums.com/20960/

Thanks.

ZHU