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
Thank you both!
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.
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! 🍻
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional