Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

How to display an Excel file in Power Apps

Like (0) ShareShare
ReportReport
Posted on 27 Sep 2023 08:47:14 by 495

Hi,

 

I have an inventory Excel file in a SharePoint library that I need to show like a read-only table in a canvas Power App.

My app uses Dataverse on Teams.

This Excel is updated weekly.

How can I show this information in Power Apps.

In Teams I have no dataflows.

 

Thanks in advance

  • EmilioRoqueta69 Profile Picture
    495 on 27 Sep 2023 at 13:12:24
    Re: How to display an Excel file in Power Apps

    Thank you both!

  • Verified answer
    timl Profile Picture
    35,013 Super User 2025 Season 1 on 27 Sep 2023 at 09:20:08
    Re: How to display an Excel file in Power Apps

    @EmilioRoqueta69 

    So long as your Excel data is formatted in a table, you can connect to it from your Teams app using the Excel Online Business connector. You can then display the data in a read-only way using a gallery control.

     

    timl_0-1695806349107.png

     

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 27 Sep 2023 at 09:03:19
    Re: How to display an Excel file in Power Apps

    Hi @EmilioRoqueta69 

     

    I would suggest to use Power Automate to achieve this.

    Via Power Automate use a schedule flow to retrieve and store the data in Dataverse.

    Then you retrieve the data into Powerapps via a collection and use the data in the app.
    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 44 Most Valuable Professional

#2
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 36

Overall leaderboard