The other day I saw an example of how prospective vendors are onboard in Dynamics 365 for Finance & Operations, and the very first step was the acquisition of the initial vendor details, which was done through an Excel import and the Data Management tools.

Although this is an OK way to do this, I was wondering if there was an easier way that we could do this, and also make the vendor request access themselves through a web page.

One of the easiest ways to gather information is through Office Forms, so I created a quick example that shows how this would be done.

Topics Covered

  • Creating a New Vendor Registration Form
  • Testing the New Vendor Request Form
  • Creating a Flow to Submit the Vendor Request
  • Using the Form to Submit a New Vendor Request

Creating a New Vendor Registration Form

The first thing that we will want to do is create the form that the vendors will be able to use to submit their initial request for onboarding. And we will do this by just creating a simple Office 365 Form.

How to do it…

Start off by going to and click on the New Form tile.

This will create our new form where we can start building our form.

We will start off by changing the default title of the form.

In this example, we changed the form title to be New Vendor Request.

And then we can add a little more information explaining what the form does and what the users should do with it.

If we click on the image icon to the right of the name, we can also do an image search for a logo that we want to add to the form.

Now that we have done that we can start adding our questions. To do this, just click on the Add question button.

Now we can select the type of question that we want to add. In this example, we will select the Text option.

That will add the question template for us.

We will set the first question to Vendor Name.

Now we can add a second question by clicking on the Add question button again. This next question will be for vendor segmentation, so we will choose the Choice option.

This will open up a different type of question format. We will start off by setting the name of the question to Vendor Type.

Then we will add all of the different vendor types that we want to ask for.

Now we will add a couple more questions. So just click on the Add question button again.

Then click on the Text option.

Set the Question name to Remittance address and for this field, check the Long answer option so that we can have multiple lines.

We will add one last question so just click on the Add question button again, and then select the Text option.

We will set the question name to Corporate address and also make this a long answer as well.

We can spiff things up by clicking on the Themes button in the menu bar and selecting a more exciting theme.

Testing the New Vendor Request Form

Now that we have created our form we can test it out.

How it works…

If we click on the Preview button, the form will open up just as the vendor would see it and we will be able to see all of our choices.

We can start off by entering a Vendor Name.

Then we can select the Vendor Type. In this case, we selected the Other option and was able to write in our type of service.

Then we can type in our Remittance Address.

And then our Corporate Address.

After we have done that we can just click on the Submit button.

This will submit the form to us.

If we want we can see all of the submissions by clicking on the Responses tab.

Creating a Flow to Submit the Vendor Request

Now that we have checked that our form looks good and works we will want to link it to Dynamics 365, and we will do that with flow and trigger an event based on the form being filled out.

How to do it…

We will start off this step by opening up the Flow site and then click on My flows.

This will show us a list of all of the flows that we have created and we can create a new one just by clicking on the Create from blank link.

We will see the suggested connectors, but Forms is not one of them so we will want to expand our search and click on the Search hundreds of connectors and triggers button.

This will allow us to search through all of the connectors.

All we need to do is type in forms, and we will be able to click on the Microsoft forms connector.

There is only one trigger for the Forms connector, so we will click on that one.

That will create our trigger event in Flow.

If we click on the drop-down for the Form Id and we will be able to see the New Vendor Request form that we just created.

Now we want to grab the details from the form, so we will click on the Next step button.

Then we will click on the Add an action button.

This will open up a list of all of the connectors.

We can filter down the actions by typing in forms and then selecting Microsoft Forms.

There is only one action that we can select from, and that is to get the details from the responses.

That will add the Get response details action.

We will want to click on the Form Id drop-down and select the New Vendor Request form again.

Then we can click on the Response Id and add the response id from the previous step.

Now we will want to add an action to update Dynamics. To do this, click on the Add an action button again.

This will open up the action selector.

This time, filter the actions to Dynamics actions and select the Dynamics 365 for Operations connector.

Then select the Dynamics 365 for Operations – Create record action.

That will add an action to the flow that will allow us to create a new record of Dynamics.

Click on the Instance drop-down and select the Finance & Operations instance that you want to update.

Then search through the Entity name list and select the ProspectiveVendorRegistrationRequests entity.

This will allow us to fill in the required fields for the prospective vendor from the responses in the form.

All that is left to do now is to give our Flow a name – here we set it to New Vendor Submission and click on the Create flow link.

Using the Form to Submit a New Vendor Request

Now that we have created our flow we can test it out.

To do this, start off by returning to the preview version of the Form.

Then fill in all of the information for the new prospective vendor, and click on the Submit button.

This will submit the form.

It will then trigger a flow to be performed.

We can drill into the flow and see that it successfully created the record in Dynamics 365.

If you don’t believe it, then just go to the Prospective vendor registration requests form and you will see that there is a new record there.


How cool is that? We used a simple form within Office 365 to capture information and then used Flow as the integration tool to update Dynamics 365. That is too easy!


Power BI has an option to create scannable QR codes that link to the reports and dashboards that you have published in the Power BI workspaces. These QR codes can then be scanned through the mobile clients, and the user will be taken directly to the report, tile, or dashboard.


How to do it…


To start off, we will link one of our KPI’s that we have on our dashboards to a QR code. To do this, we will want to select a tile and select the Open in focus mode option.

This will open up the KPI, and we will then be able to click on the link and select the Generate QR Code option.

This will create a QR code for us that is linked to the KPI. To save the code, just click on the Download button.

Then you will be able to save the QR code away to your desktop.

Now we can open up the file and print out the code.


How it works…


To see this in action, all we need to do is open up the Power BI Mobile app and select the Scanner option. This will open up a scanner that we can then use to read the QR code.

All we need to do now is to scan the QR code that we printed out.

That will take us directly to the KPI that we created the KPI for.

From there we can drill back to the Dashboard that the KPI was on.

We can even drill into other tables and charts on the dashboard.

And if we want we can even see the report that we used to create the Dashboard from.




Creating QR Codes that are linked to PowerBI Dashboards, Reports and Tiles is a huge feature. You can use this to link your reports to physical locations.

For example, you can create a dashboard that shows all of the metrics for a particular piece of machinery and then attach it to the machine. All you need to do to see how the machine is performing is just to scan the QR code with your phone. How cool is that?

Power BI allows us to create embeddable versions of any of our reports that we are able to share with others through links and also embed within websites and applications through an iFrame control.

How to do it…

To start off, we will want to open PowerBI and find the report that we want to share as an Embedded report.

Now we will want to publish the report to make it embeddable.

To do this, just click on the File drop-down menu and select the Publish to web option.

This will make the report available as an embedded report and will also create a link to the report that you can email to people and also it will give you the embeddable iframe HTML code that you can use to embed directly into websites.

After you have created the embed codes, you can access them by clicking on the Settings icon and then selecting the Manage embed codes option from the drop-down menu.

This will take you to a view where you can see all of the embed codes that you have created.

To see the codes again, just click on the and select the Get code option.

This will show you the same form that we saw when we created the embed code, along with the URL and the iframe code.

How it works…

To see this in action, all you need to do is copy the URL and paste it into a browser.

Keep in mind that this is a publicly available report now and anyone with the embed code or URL will be able to see this report.


Being able to publish out or reports as embedded reports gives us a very easy way to publish the reports without allowing users to edit the details. This is ideal for internal websites, and also if we just want to embed the reports in our own applications.

PowerBI Online has a great feature within it that allows the users to create dashboard tiles just by asking questions, and this has always been a crowd pleaser to show to the users.

But if you have been using the PowerBI Desktop to create your reports then you have had to do this the hard way by manually selecting the fields.

Great news. There is a Preview feature that is now available within PowerBI Desktop that adds that same natural language query option that is available within PowerBI Online, but now it is within PowerBI Desktop.

In this article we will show you how to enable this feature and also how it works.
Read More

As a little background, I usually would set up all of my demo data within Operations, but now that we are in a connected world and I can send Account details from Sales to the Customer records in Operations, I have been trying to embrace the other side of Dynamics 365, because there are a few features that we on the Operations side can’t do.

So, today I was setting up some data today for a demo, and also testing the Sales to Operations integration and I discovered the Bing! Maps API and GeoCode feature in Sales and thought it was worth showing this small demo example.
Read More

Last week I saw something interesting in one of the presentations at Ignite. There is a new way to access all of the Data integration and environments for PowerApps.

How to do it

Just go to

It is the same as going to PowerApps, and then accessing it through the settings:

But, it may be a better portal if you just want to show the integration, and not meander through the PowerApps page.

The Data Management tools within Dynamics 365 for Operations open up a whole slew of different ways that you can get data into the system. And it also has an option to create batch import job that will allow us to watch for data.

This opens up a whole slew of options for us because we can use these batch jobs to import data from other systems, because they can just package the data up for us and then send us the data. It creates a very easy way to create integrations because these data packages can also be sent to the Data Management batch job through a web service interface.

Now if I were a coder, then I would just call the service from my other system and it would create the package and send it to Dynamics 365 for Operations, but there are also other options available to us.

But what if you want to have a system that you don’t control integrate with Dynamics 365 for Operations, or maybe you are getting files from a partner that you want to automatically upload into the system?

Then you can go a little old school and have it create a file based integration.

But if you do that, how do you get the file to be picked up and processed within the Data Management service?

The simplest answer is to use Flow to watch for the files and then grab them and send them to the Data Management service for you.

And if you are looking for somewhere to All you need is somewhere for the file to be put, and OneDrive is a great option.

In this walkthrough we will show you how to tie all of this together to create your very own file based integration,.