Reply To: Excel Appending Records to BC via Power Automate

  • Ian Ray

    Member
    July 18, 2025 at 8:31 pm
    Up
    0
    Down
    ::

    Use the “Dynamics 365 Business Central” action

    “Create Record (v3)”

    Choose your environment, Company. Use API category 2.0

    Table name
    salesQuoteLines

    Permissions won’t be an issue as Power Automate will use Proof Key for Code Exchange (PKCE) behind the scenes. The initiator of the flow logs in with their Entra ID credentials if not already logged in. This is easier to work with and also the safer way of granting permissions since the auth code can only be redeemed by the client that requests it.

    Are you using HTTP Get because of on-premises Business Central? That does make it trickier.

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!