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.
Microsoft Office Forms
Microsoft Dynamics Business Central
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|
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|
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 😀