The form should these 4 fields with the following data types: If you don’t have access to Microsoft forms just use the insurance claim form I created here. We can use Microsoft Forms – a free form builder that comes with your Office 365 license for this purpose.

To do this example we need to build an insurance claim form to open in our web browser. Using Power Automate Desktop the company automatically enters each claim into a form on their insurance company’s website.Ĭreate An Insurance Claim Form With Microsoft Forms Introduction: The Insurance Claims WebsiteĪ construction company has a list of employee insurance claims in an Excel spreadsheet. Run The Power Automate Desktop Flow To Perform Data Entry.Insert A For Each Loop To Repeat Data Entry Actions.Use The Web Recorder To Capture Data Entry Actions.

Test Desktop Flow Actions To Read The Excel Worksheet.

Make An Excel Spreadsheet With Insurance Claims Data.

Create An Insurance Claim Form With Microsoft Forms.

Introduction: The Insurance Claims Website.

In this step-by-step tutorial I will show you how automate data entry from Excel to a form on a website. Its absolutely amazing to watch as your computer quickly completes the boring task that used to take you hours. One of the most popular use cases for Power Automate Desktop is taking data from an Excel and file and entering it into a form on website. Power Automate Desktop is a free application from Microsoft you can download to automate personal or business-related tasks on any Windows computer.

Install power automate desktop