web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Blogs / Power Apps - Community Blog / Create Data in Data verse f...

Create Data in Data verse from Excel using Power automate

Views (8544)
Devikumari Krishna Profile Picture Devikumari Krishna 988 Super User 2024 Season 1
  • 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

*This post is locked for comments

  • FrankFornasiero Profile Picture FrankFornasiero
    Posted at
    Create Data in Data verse from Excel using Power automate

    Hi Devikrishna, I have to collect the data to insert into a dataverse table picking them up from some columns of an excel table (that is not from all of them, there’s not correspondence 1:1 with the dataverse table fields).

    How can I do?

    Thank you very much

    Frank

  • Wilson_Rojesh Profile Picture Wilson_Rojesh
    Posted at
    Create Data in Data verse from Excel using Power automate

    My Scenario is an xlsx file gets uploaded to a share point library we need to extract the file data and insert it into a dataverse using Power Automate. Could anyone please help me with a solution