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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Excel Online (Business...
Power Apps
Unanswered

Excel Online (Business) connector, setup not showing all items in folder

(1) ShareShare
ReportReport
Posted on by Matuvus 23

Hi everyone,

 

I'm new to Power Apps and I'm trying to understand why I can't find my Excel file when setting the up the connection.

 

I'm using the Excel Online (Business) connector (file is store on Sharepoint) , I can browse to the required folder but then, the file doesn't show up.... it's not on the list.

 

Actually, there's a bunch of stuff that doesn't show up, there's more than 350 items in that folder.

 

I guess there's some kind of limit (try to search the internet.... didn't find what I was looking for)

 

I tried to connect to another Excel file in another folder of the same general path : works fine.

 

I'm trying to use the option : "Enter the location of your Excel document" but I always got a error.

 

I'm clearly missing something here.... please enlighten me

 

Thx

Categories:
Building Power Apps
  • Jnas Profile Picture
    Jnas 30 on at

    For me the channel of the team wasn't even showing up. I entered the info manually, maybe that works for you (Maybe that's already what you did when you wrote you used the option "enter the location of you excel document).
    This here helped me: https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-power-automate-to-grab-files-stored-in-private-teams/td-p/1863463
    I opened the channel via teams with "open in sharepoint", then clicked on "Start" and copied the url from that site. Pasted it into the field of the connector that says "Location". Then I just entered "Documents" in the field "Document Library" (apparently it's the same for all channels if you didn't make a dedicated custom document location in the channel. On the linked topic above there's an comment mentioning that). Then I entered "/channelname/filename" in the field "File" (replace channelname with the name of the channel and filename with the name of your file incl. extension).

  • Matuvus Profile Picture
    Matuvus 23 on at

    Hi @Jnas,

     

    Thanks for your input.

     

    Actually, my issue is when I'm trying to add and configure the connector in the Power Apps IDE, it doesn't show in the : 

    Matuvus_0-1701883755800.png

    But I'm able to specify the path and file name when I create/setup a step in Power Automate.

     

    I've tried to use the same info (from Power Automate) and put it in the first box in Power Apps.... to no avail.

     

    I can't find the right format to use in that box. 

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 394 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans