Power Platform Community Forum Thread Details

I have a basic table in my local SQL Server that I want to insert records into whenever an item is created on Business Central.

To get started, this is the table and fields in Business Central I want to extract from and insert into my SQL table.

Table and Fields in Business Central

First question is why are the tables names different, Item (in Business Central) but items (in Power Automate)?

Flow to update SQL table with new item created in BC.

Second question why are the fields names different, No. (in Business Central) is Number (in Dynamic Content)?

Also, why does the Dynamic Content not show all available fields from Item table. Cannot see No. 2 or Description Fields. I did try an expression of outputs('Get_record')?'[body'/description'] but this just failed?

Dynamic field names do not match the field names in BC, No. (in BC) = Number (in Dynamic Content). Also not all fields are showing in Dynamic Content.