Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Can you connect to OneDriveForBusiness using PowerApps alone?

Like (0) ShareShare
ReportReport
Posted on 24 Mar 2022 21:53:04 by 235

Hello,

I need help.  

I want to connect my PowerApp to OneDrive for business.  I want to list out the contents of a directory using wild cards, if possible.  I THINK I need the API and I believe I have to "Connect" to the OneDrive for Business API to do this because I want to use a dynamic filename.    Something like /Root/PortalDirectory/Attachments/*CaseID*   that would list out the files in that directory matching my CaseID.

 

But before I can even begin I need to connect to the OneDriveForBusiness connector and when a friend was trying to help me, it seemed to expect an excel file.  And then when I try to search for that, I see a lot of information connecting using Flow or Power Automate.  I simply want a direct connection from my app.  Is that possible?  If so, how?

 

Thanks very much

Categories:
  • TheRobRush Profile Picture
    11,121 Super User 2025 Season 1 on 25 Mar 2022 at 14:51:53
    Re: Can you connect to OneDriveForBusiness using PowerApps alone?

    I would just create a flow that runs and retrieves the contents of the onedrive, and the link to each file, then returns them to powerapps. It should be pretty straight forward. I would expect it to even allow you to open those files on your device outside of powerapps via launch() command

  • AmyF Profile Picture
    235 on 25 Mar 2022 at 13:56:30
    Re: Can you connect to OneDriveForBusiness using PowerApps alone?

    @BCBuizer   Thanks very much, but messing around with the OneDrive URLs, I find I can do this without the API or Connector.  I just did a search on OneDrive for a particular caseID (not from within the app) and it filtered it out in the browser, so I was able to then test the URL using Launch and it worked just as it would if you were going after something on your local system.  So I can construct the url needed...   Stub1+CaseID+RemainderOfUrl.  I had tried that before and was unable to isolate what I needed.  I thought that an API and connector was overkill for what I needed and couldn't believe it was going to be so difficult to just get a listing, but it is my ignorance of OneDrive and messing up the "stub" that confounded me.  OD and PA are new to me.  Eventually the OneDrive directory will be moved to another area of our business onedrive and I will only have to change the stub when that happens.  

     

    Thanks very much and I'm going to mark this as solved.

  • Verified answer
    BCBuizer Profile Picture
    22,046 Super User 2025 Season 1 on 25 Mar 2022 at 13:07:12
    Re: Can you connect to OneDriveForBusiness using PowerApps alone?

    HI @AmyF ,

     

    All I mentioned is that the OOB OneDrive connector doesn't provide the functionality you described, but that doesn't mean there is no way. I don't have experience with this, but the below are some ideas that may work:

    - File system connector https://docs.microsoft.com/en-us/connectors/filesystem/ (requires a gateway)

    - SharePoint connector https://docs.microsoft.com/en-us/connectors/sharepointonline/ (requires sync between OneDrive and SharePoint library)

    - Custom Connector https://cloudatica.medium.com/power-apps-custom-connector-using-microsoft-graph-apis-d3b1d821e4fd 

     

    @RandyHayes@WarrenBelz, @TheRobRush : Anything you can add on the subject?

  • AmyF Profile Picture
    235 on 25 Mar 2022 at 10:49:11
    Re: Can you connect to OneDriveForBusiness using PowerApps alone?

    So, just to clarify, there's no way to use the OneDriveforBusiness API  from PowerApps?

    I'm finding this so hard to believe - I'm sorry but simply listing a directory's contents?  CAN'T be done?  What is up with that?  I'm sorry I'm incredulous about this.  It baffles me.

  • BCBuizer Profile Picture
    22,046 Super User 2025 Season 1 on 24 Mar 2022 at 22:05:33
    Re: Can you connect to OneDriveForBusiness using PowerApps alone?

    Hi @AmyF ,

     

    There are connectors for OneDrive you can add to PowerApps:

    BCBuizer_0-1648159447740.png

    However, in reality they only allow you to connect to Excel files that are stored on OneDrive:

    BCBuizer_1-1648159513471.png

    So the short answer to your question is: No

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

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started