How to use Forms - Flows - Business Central integration to build your masters in Business Central

Problem Statement:

Few months ago on a client requirement gathering session for Business Central, I realized that the client is asking for portal where the Vendors / Customers can fill in their basic data so that the data is correct and it saves our time to prepare the master.  The easiest way of doing this was by using Microsoft Forms. In this case, I need it for Vendors, so let's see how we can use Forms, Flow and Business Central and integrate them together.

Pre- Requisites:
Microsoft Flow
Microsoft Office Forms
Microsoft Dynamics Business Central

Solution:
The solution I found was creating Form and using Flow integrate the data from the Form into Business Central
1. Create Form with fields which you want to set on the Vendors

Creation Form fields.

2. Create Flow to take each record inserted in Form and integrate this record to Business Central

Creating Flow which loops through each record and passes it to Business Central

Output:
After inserting the data into Forms, automatically MS Flow runs to integrate this record into Business Central.

Before the creation of the Vendor

During the submission of the data in Forms

After the creation of the Vendor

Vendor details as mapped in the Flow

Conclusion:
Thus using MS forms, you can only insert/update/delete the data. You cannot view existing data into the forms. I'm still exploring MS Flow I'll add a few more blogs to make you more familiar with ready-made tools that can help us minimize our development efforts.

I hope you guys like this solution.
Happy Flowing 😀