cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Emolo
Frequent Visitor

Share Canvas PowerApps with users without sharing the sharepoint list

Hello everyone, I have created a Canvas PowerApp for my company to manage working hours for tasks. It works very well and I was able to integrate it very well with Planner. Tasks are written on a sharepoint list. I would not want this sharepoint list to be read by users using the power app. is it possible to do that? Restrict access to the sharepoint site to users who use the powerapp. Thank you and see you soon . 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi everyone, thank you so much for your support and also for this I left a kudos for everyone. I decided to abandon the sharepoint lists for a common data service entity because it is more flexible in managing permissions. Thank you all for the advice. Good job

View solution in original post

9 REPLIES 9
eka24
Super User
Super User

Check this post on same issue .
https://powerusers.microsoft.com/t5/Building-Power-Apps/Allow-PowerApp-users-to-submit-data-to-share...

If you like this post give thumps up. If it answer your question mark as a solution
Emolo
Frequent Visitor

Thank you so much for your answer. You've earned a thumbs-up. But I wonder: is there any way with power apps to use a different database (not necessarily sharepoint list) so that only the app can be accessed? Thanks

eka24
Super User
Super User

There are many connectors including Sql, MySQL, excel ...
https://www.carlosag.net/PowerApps/Connectors/

Look at the common data service! 🙂

Hello, I created a Common Data with an administrator account, from another account I try to access the app and enter the data but I have the error of missing permissions. How could I authorize the app instead of the user?

Just like Sharepoint, excel, etc. you have to provide the user access to the datasource as well as the app. 

You can do this by going to admin.powerapps.com > Environments > select your environment > security tab > click 'Assign Security Roles'. This will take you to a list of users where you can assign a role to the user

Hi everyone, thank you so much for your support and also for this I left a kudos for everyone. I decided to abandon the sharepoint lists for a common data service entity because it is more flexible in managing permissions. Thank you all for the advice. Good job

YAY! that's great news Emolo! welcome to a new world of awesome!

Yes, You can use Microsoft Dataverse as a database to restrict access to viewing the DB(Tables/Entities used by your Canvas App), unlike Sharepoint where we have to share a Sharepoint list with users who are accessing the Canvas application.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,194)