The Enabling Technologies Blog

Our team of Cloud Strategy Advisors, Solution Architects, Engineers and former C-Suite Executives work diligently to provide our vistors with the most pressing information.

Brandon Schoch /

{Watch} Mapping Data From a Microsoft Form Submission to a Dataverse Choice Column

In the following video, we will discuss two design patterns that you can use for mapping data received from a Microsoft form submission to a Dataverse choice column. We will show you the entire process from the beginning by building the dataverse table, the Microsoft form, and the Power automate flow from scratch. The first design pattern utilizes the standard Switch statement in Power Automate, and we will discuss a few pro/cons for that approach. The second design pattern uses a JSON object in the Compose action, which is a bit more advanced but lets you build a much cleaner automation flow that will be easier to maintain or make changes to in the future.

Power Platform Choice Mapping-1



Work with our team of Cloud Computing Consultants who have done this so many times they know all of the “minefields” to prevent missteps.