Power Apps for Power Bi

Hi Fairos ,

Thanks for the update!

The reason you're likely not seeing the file is because Power Apps connects more reliably to SharePoint Lists, not directly to Excel files stored in a SharePoint document library. Those are treated differently in SharePoint.

As a quick check, go to your SharePoint site -> Site Contents and confirm whether your Comments data appears under Lists or if it's just stored as a file in a document library.

If it's currently an Excel file, that would explain why you're having trouble locating it from Power Apps.

While Power Apps can connect to Excel files stored in SharePoint, it generally isn't recommended for multi-user scenarios like a Visitor Management System. Microsoft notes that if the Excel file is open or being edited by another user, read/write operations can become unreliable. With multiple users updating comments simultaneously, this can lead to conflicts or failures.

Reference; Power Apps data sources - Training | Microsoft Learn

A cleaner approach would be converting the Excel data into a proper SharePoint List. You can do this directly from SharePoint using:

New -> List -> From Excel

After the list is created, in Power Apps go to:

Data -> Add data -> SharePoint

Then enter your SharePoint site URL and select the newly created List. At that point, it should become visible and connect successfully.

Reference:
Connect to SharePoint from a canvas app - Power Apps | Microsoft Learn

Hope this helps. Please reach out for further assistance.
Thank you.