cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DeviKrishna
Super User
‎01-25-2022 02:37 AM

Create Data in Data verse from Excel using Power automate

  • Login to https://make.powerapps.com
  • Choose the environment.
  • click on Flows.
  • Choose the Instant Cloud Flow -> create a name and choose the PowerApps (V2) Trigger.
  • Add a Step and choose PowerApps as admin ->Get Apps as Admin

image-5.png

 

 
  • To know the Environment ID in Environment Name field ,
  • Click on Settings ->Session details->PowerApp Session Details ->Copy the value against Environment ID.

image-6.png

 

  • Add a new Action below Get Apps as Admin step -> List rows present in table.
  • Choose the Location. In my case I have kept the excel file in SharePoint.
  • Choose the Document Library, File and table name from excel file from where we need to read the data.

image-7.png

 

  • We need to loop through the list data output and create records in Data verse.
  • For this , choose the loop control Apply to Each.
  • Select the Output from previous step with ‘value’ returned from the List above.

image-8.png

 

  • Choose the Microsoft Data verse ->Add a new Row action.
  • Select the entity. In my case I am reading data from excel to create records in contact entity.

image-9.png

 

  • Map the mandatory attributes from value set to columns .
  • Save the Flow.
  • Apply the flow check and test the flow.

image-10.png

 

  • The Flow is complete and ready to use.
  • Reference to SharePoint list used in the flow,
  • image-11.png
Comments