Business Central & Power Automate | Create Flows in Microsoft Dynamics 365 Business Central

Microsoft have released functionality to allow triggering of Power Automate flows from within Business Central.
In this video we show examples, setup and talk about how this new feature is one of the best things that Microsoft have released in the product in the last few years.

[@Justdre9370]

What version of Business Central do you need to ave powerauotmate features?

[@PRouth]

Hi, brilliant video!! Is it possible to also make a video on how to automatically update customer records when customer records are filled via google/Microsoft forms ?

[@DynamicsConsultants]

Hi, thank you for the request, we will keep it in mind for future videos.

[@user-jj6dj3oj7s]

Thank you for the video! If you have BC license, do you still need to acquire a Power Automate license to use the "Premium" triggers?

[@DynamicsConsultants]

This is a great question. The simple answer is that if you have a Business Central SaaS license then you are then licensed to use premium connectors. However, it is important to note that this is only in the case where you have a Power Automate Flow that is in “the context of Business Central”; ie that is to say that without Business Central you wouldn’t require the Flow. It is also important to note that Business Central on premise licenses do not cover Power Automate licensing.

[@ioannistsak9843]

Thanks for the video. One question though, how would you retrieve the salesperson email from the customer? It seems that this table (salesperson/purchaser) along with others, is not currently available in the Get Record (V3) step.

[@RizwanBashir-du9sp]

Try using Find Record (V3) action, it is almost similar(apart from the filter, sort options), but the output is a bit detailed.

[@DynamicsConsultants]

There are a limited number of tables available as standard, you would need to create an API for salespeople and then use that to retrieve the data.

[@CopticCommentary-nu6xj]

Do you have a resource on how to create a BC trial account without actually having a company/school email ID? I am having trouble getting a trial in BC (works fine in Dynamics 365). Thank you.

[@DynamicsConsultants]

Hi, thank you for your request. Generally a work or school email address is required to perform a trial.

[@stefann92i]

@copticcommentary-nu6xj you can also create a professional 1 month trial account on Microsoft 365 then use it to create your BC account.

[@muhammedsezen3599]

Can you tell me what is in condition as string? Thanks

[@DynamicsConsultants]

We're using the retrieved list of Teams channels to see if there is one that contains the customer name. The string is the following: string(outputs('List_channels')?['body'])