Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

How to create an Implicit Connection in PowerApps?

(0) ShareShare
ReportReport
Posted on by

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.

  • timl Profile Picture
    timl 33,744 on at
    Re: How to create an Implicit Connection in PowerApps?

    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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard