In this blog, i will show how to create records in dynamics 365 from excel automatically using power automate

Now i have data in my excel sheet

Add this excel file in your SharePoint

Next create a new power automate flow

Next take List rows present in a table from Excel business and give all the inputs like below

Next add the “Add a new row” from Dataverse and next when trying add any data from excel it will automatically add the step inside the apply to each loop

After adding the excel fields in Add a new it added the Add a new row inside the apply to each and next add the remaining fields

Now save and run the flow

Now the records are created in crm from the excel

For any Help or Queries Contact us on info@crmonce.com or +91 8096556344