cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino
Level 10

Licensing needed for SharePoint connection to PowerApps?

Hi, I can create a user in our domain who has a trial license for PowerApps but no license for Office365.

They can run an app that has a connection to an Azure SQL DB.

They can view our SharePoint Online sites and document libraries etc.

However, when I add a connection to SharePoint in PowerApps, they are not allowed to go further since the Allow button is disabled (see below).

Is this by design?

Does it mean that a user needs an Office365 license in order to use a PowerApp that connects to SharePoint Online?

Many thanks for any insight.

 

PS I read this illuminating exchange by @audrieg and @sarafankit but it did not help with my particular issue.

 

__.JPG

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
PowerApps Staff sarafankit
PowerApps Staff

Re: Licensing needed for SharePoint connection to PowerApps?

 

Thanks for the information, are you or were you using the Office365Users connection as well in the app?

 

Can you please:

  1. Open the app in PowerApps Studio
  2. If you have the Office365Users connection, remove it & add it again. Or if you don't have it just add it once.
  3. Save & Publish the app
  4. Now run the app with the new user

Let's see if this gets you unblocked, I am still trying to figure out what is happening, it doesn't seem like a licensing issue per se.

 

View solution in original post

Highlighted
Meneghino
Level 10

Re: Licensing needed for SharePoint connection to PowerApps?

Hi @sarafankit

Apologies, my mistake.  Indeed the issue was not with the SharePoint connection or with the Office365Users connection, but with the SQL Server connection.  I had forgotten that this type of connection is not shared automatically when the app is shared, but needs to be shared as well.

Many thanks for the quick and useful help!

 

View solution in original post

5 REPLIES 5
PowerApps Staff sarafankit
PowerApps Staff

Re: Licensing needed for SharePoint connection to PowerApps?

Can you please provide us the session id where you are seeing this issue? If you use PowerApps mobile player or studio for windows, you can get that via Account > Debug > Session Id

 

 

If you cannot find the session id, please provide the email-id of the user you have created.

Meneghino
Level 10

Re: Licensing needed for SharePoint connection to PowerApps?

Hi Sarafankit, thanks for getting back to me.
The session id is as follows,
Session ID: 131a2ce4-37b7-1e12-567e-7b1c04b0105a
In a desperate attempt to get this working I even bought a license, but it disn't hellp.
Please help me!
PowerApps Staff sarafankit
PowerApps Staff

Re: Licensing needed for SharePoint connection to PowerApps?

 

Thanks for the information, are you or were you using the Office365Users connection as well in the app?

 

Can you please:

  1. Open the app in PowerApps Studio
  2. If you have the Office365Users connection, remove it & add it again. Or if you don't have it just add it once.
  3. Save & Publish the app
  4. Now run the app with the new user

Let's see if this gets you unblocked, I am still trying to figure out what is happening, it doesn't seem like a licensing issue per se.

 

View solution in original post

Steelman70
Level 10

Re: Licensing needed for SharePoint connection to PowerApps?

Hi Sarafankit, thanks for the quick follow-up.
I was using the Office365 Users connection in an earlier version of the app, but removed it since the new user was not licensed at the time.
I am back in the office on Monday and will try what you suggest.
Thanks again for the quick follow-up.
Highlighted
Meneghino
Level 10

Re: Licensing needed for SharePoint connection to PowerApps?

Hi @sarafankit

Apologies, my mistake.  Indeed the issue was not with the SharePoint connection or with the Office365Users connection, but with the SQL Server connection.  I had forgotten that this type of connection is not shared automatically when the app is shared, but needs to be shared as well.

Many thanks for the quick and useful help!

 

View solution in original post

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 185 members 5,070 guests
Please welcome our newest community members: