Wednesday, October 5, 2022

How to create Microsoft Dataverse table record through Microsoft Form after approval by using Microsoft Flow

Introduction

In this topic, we'll add a new record in Dataverse table with Microsoft Form response through Microsoft Flow. We'll explain simple steps and give some useful insights.

In this case, we'll create Microsoft Form and then Microsoft Flow through which we'll add responses of Microsoft Form in Dataverse table after Approval.

Open Microsoft Form


Create New Form as 



Open Power Automate


Create Automate Cloud Flow



Select trigger when Microsoft form response submitted and add name of flow




Select Form ID (Newly created form in previous step)


Add Approval component and add related details


Add condition in flow where outcome is approve then create record in Dataverse Table. 


Save the Flow

Open Newly Create form and fill it. 



After Submit the form Approver will receive email with form details



When approver approve this then flow ran successfully.



Now Open Dataverse Table in which record is created we selected in Microsoft Flow



We can see Dataverse Table record is also created at the same time after approval. 


In this post, We created Microsoft Dataverse table record through Microsoft Form after approval by using Microsoft Flow.