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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Import data from excel...
Power Apps
Unanswered

Import data from excel to dataverse using power automate in power apps

(0) ShareShare
ReportReport
Posted on by 54

Hi All, 

 

        In Power apps by clicking on a button an excel file needs to be uploaded & that uploaded excel file needs to be imported to Data Verse using Power Automate. Kindly help me to create a power automate flow for this process.

 

@bipinshan can you help me on this?

I have the same question (0)
  • v-dezhili-msft Profile Picture
    Microsoft Employee on at

    Hi @Nathan_m1 ,

     

    I have a test for your reference.
    First, I use an Edit form control to save the uploaded Excel file to the item whose list ID is equal to 6, and then save the attachment of the item to OneDrive, so that I can use List rows present in a table action to get the Excel file The content of the table (note that the name of the table in the Excel file must be Table1).

    vdezhilimsft_0-1672912072448.png

     

    vdezhilimsft_1-1672912072448.png

     

    vdezhilimsft_2-1672912072449.png

     

    vdezhilimsft_3-1672912072450.png

     

    vdezhilimsft_4-1672912072452.png

     

    vdezhilimsft_5-1672912072453.png

     

    vdezhilimsft_6-1672912072453.png

     

    vdezhilimsft_7-1672912072454.png

     

    Best Regards,

    Dezhi

  • Nathan_m1 Profile Picture
    54 on at

    Thanks @v-dezhili-msft  for your solution, actually this is feasible if you are having less number of datas but in my case if an user uploads a excel sheet which contains around 30 columns and 450 rows in power apps & the uploaded excel sheet needs to be imported to dataverse using Power Automate. If you are having any idea on this kindly suggest me @v-dezhili-msft .

     

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard