Power Platform Community Forum Thread Details

Hi All,

I have a requirement to import a simple Excel Online table hosted in a SP document library into a Power Apps collection. After a bit of googling I see quite a few solutions using the Excel Online (Business) connector and then browsing to the SP document library, selecting the Excel Workbook and then selecting the table.

The problem is at the moment I have 3 users who each have a separate Excel sheet that they work on. The table format is the same for each user so I could create 3 separate connections. The problem with this approach is there will be more users who will need similar requirements and I don't want to keep setting up connections

I suspect I may have to use Power Automate and trigger from a button Power Apps and then send the Location and Filename to Power Automate from a List of UserEmails, Location and Filenames.

Has anyone set up similar functionality or can they provide a link to useful Blogs or Video's to help me achieve this?

Many Thanks

Categories:

General Questions