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 / How to create an Impli...
Power Apps
Unanswered

How to create an Implicit Connection in PowerApps?

(0) ShareShare
ReportReport
Posted on by Masum172

We have a PowerApp which is using an Excel Spreadsheet as a Data source to do LookUps (sitting in Sharepoint). We noticed we are having to provide end users access to this Spreadsheet for them to be able to use the app with no errors. Is there a way we can set implicit permissions in the app to allow them to use the App without having to provide them access to the Data source as this appears on user's Office 365 Portal and they would go into it and make changes without knowing.

 

Is there a way around this i.e implicit permissions in the App or using an alternative Data source?

 

Any help would be appreciated.

Categories:
Building Power Apps
I have the same question (0)
  • timl Profile Picture
    timl 36,738 Super User 2026 Season 1 on at

    Hi @Masum172 

    It's not possible to grant users implicit access to an Excel spreadsheet. Power Apps supports implicit/shared connections to certain data sources - Excel isn't one of those.

    An alternative is SQL Server, which does support implicit connections. This alternative would require all users to have a premium license, so this might not be a viable solution if you don't already have premium licenses.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

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