Not all fields available on Create Record (V3) for Business Central Items Table

Like (0) Share

Report

Posted on 9 Apr 2024 14:01:39 by AN-01071315-0

I am new to Power Automate, so please forgive my ignorance.

I am creating a flow to read in a CSV file and check that all records exist on the Items table, where they don't I want to create a new record

However, I need to set the VAT Prod Posting Group but this field doesn't seem to be available. As it is a standard field I don't understand why I cannot set it?

I have read that I can add this using extensions or custom APIs, but I'm unsure how to progress with this.

Can anyone advise?

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on 25 Apr 2024 at 10:20:50

Like (0)

Report

Re: Not all fields available on Create Record (V3) for Business Central Items Table

@AndrewJN you can refer to this blog on guidance for creating custom connector https://www.annajhaveri.com/exploring-the-world-of-custom-connectors-in-power-automate-for-business-central
AN-01071315-0 3 on 24 Apr 2024 at 11:28:21

Like (0)

Report

Re: Not all fields available on Create Record (V3) for Business Central Items Table

@annajhaveri Thank you for this information. The field is on the page and I can easily create a page-level web service.

Could you please give me a quick bit of guidance on how to create a custom connector?
annajhaveri 8,531 Most Valuable Professional on 24 Apr 2024 at 11:24:36

Like (1)

Report

Re: Not all fields available on Create Record (V3) for Business Central Items Table

@AndrewJN if you have the field available on the page, you can create a page-level web service and then create custom connector in Power Automate to create record using that web service.