Skip to main content

Using Forms, Flow, and Business Central integration to create your vendors

by Olister Rumao
Software Engineer, CloudFronts Technologies

A few months ago, I was gathering client requirements for a Dynamics 365 Business Central project, when I realized that the client was asking for a portal where the vendors  and customers can fill in their basic data to save time when preparing the master.  The easiest way to do this is by using Microsoft Forms. Let's take a look at how we can use Forms, Flow and Business Central integrated together to achieve this goal.

Pre- requisites

  • Microsoft Flow
  • Microsoft Office Forms
  • Dynamics 365 Business Central

Solution

The solution I found was creating a Form and using Flow to integrate the data from the Form into Business Central. Flow directly integrates with standard Business Central entities. All you need to do is select a Business Central template in Flow and rearrange it, as shown in the screenshot below:

select_business_central_template_and_rearrange.jpg

1. Create a Form with the fields that you want to set for the Vendors.

create_a_form_fields_set_for_vendors.png

2. Setup Flow to take each record inserted in Forms and add it to Business Central

add_records_into_business_central.png
Users should know that there are some licensing concerns with pushing data into Business Central from Flow. Most significantly, Flow only has 750 free executions for a single user every month. If you need more then you will have to add to the plan.

Output

Once set, Flow runs automatically and loads the form data into Business Central.

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Olister Rumao

Olister Rumao is a Software Engineer with CloudFronts Technologies. Being an innovative mind, Olister has shown his capability to master the Microsoft Dynamics ERP systems. His constant research and extraordinary coding ability has led him to successfully deliver on US based client projects related to ERP implementations. He has transformed himself to adapt to the new system from Microsoft Dynamics NAV to Business Central and gained immense expertise. 

CloudFronts is a Microsoft Certified Gold Partner which offers complete Dynamics 365 (Customer Engagement, Finance and Operations, Business Central) implementations, Power BI Analytics, Office 365 and Azure Infrastructure services. The team has deep expertise in delivering and supporting the customers through all aspects of their implementation from strategic technology consulting and road-map, requirements assessments, project implementation, training, migration to post go live managed services and support. The company has vast experience in digitally transforming corporates in sectors such as banking & financial services, professional services, pharmaceutical, manufacturing, F&B, retail, agro-tech, non-profit and several others. CloudFronts commenced its operations in the year 2012 to empower organizations around the world, do more with technology.

Check out our customer success stories here: https://www.cloudfronts.com/customer-success/ and follow us on linkedin now: https://in.linkedin.com/company/cloudfronts

Linkedin of Olister Rumao: https://in.linkedin.com/in/olister-rumao-1156a173

More about Olister Rumao