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

Power Automate : Business Central Connector

(0) Share

Report

Posted on by Inkey Solutions

2,100

Hi All,

I want to create One Power Automate Flow For Integrating the D365 sales 'Customer Address' table Fields with the D365 Business Central 'Ship-to Address' table fields. But the problem is that no OOB table is found for ship-to address in the business central connector. That is why I created one custom API page for the Ship-to address table fields.

>> Another thing is that to insert the new record in the table using the business central connector we need primary key values for both primary keys in the table

>>I also added these two fields to my custom API page. but however, it could not be visible in my connector. please see the below screen print for that.

Above Screen print for my custom API page.

>>Below Screen print for Business Central Connector

So, I can get all other fields except those two primary keys. I want the primary key too here. Can anyone please give a solution for this?

Any help would be appreciated.

Thank you.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Have you set an odatakeyfields? You can set multiple fields too. Check this out: www.cloudfronts.com/.../

Was this reply helpful? Yes No
Inkey Solutions 2,100 on at

Like (0)

Report

Yes, I have set the OdataKeyFields as PK. when I get the data using Postman that time I get all the fields as expected.

However, Still, I could not find both PKs in my Power Automate- Business central connector. please see the screen print for the same.

>>Postmen Screen print:

>>Power Automate - Business Central Connector:

>> Custom API Page:

Is there any another way for the solution?

Thank You.

Was this reply helpful? Yes No