Unanswered

Problems sharing powerapp

(0) Share

Report

Posted on by KGee1

Hi,

I have created a PowerApp for my organisation, but I am having some trouble sharing the app with the wider community. My app uses SP List as a data source (which sits on my personal OneDrive), but the PowerApp is in a public environment.

When I grant users user rights in PowerApp and Edit permission in my SP List, Powerapps keeps returning the error message below (MTP Test II is the name of my List):

It seems that the only way my users are able to see the data in the form is to make them a co-owner of the form, grant them edit rights in the SP List AND share the link to the SP List with them (not so sure if this last part was necessary, but it was only after I shared the link that people could see the data in the PowerApp).

Ideally, I would like it so that everyone in the organisation can use the App and add data to the SP List, but I do not want users to go directly into the SP List and alter the data in the list.

Any suggestions on how users can start using my app, without going directly into my data source?

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KGee1 ,

When you refer to SP List as a data source (which sits on my personal OneDrive) - do you mean an Excel file on your OneDrive (as a SharePoint List cannot be filed there) ? Co-owner of the app does not assist with sharing (only editing rights for the app). Also by "wider community" I assume you mean other users in your organisation ?

Was this reply helpful? Yes No
KGee1 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks for your help, I realise the mistake in my thinking - I had assumed that the SP List was hosted on my personal OneDrive (not the case, its hosted in my organisation's environment) and the wider community = people in my organisation.

I want to be able to share the app and allow anyone from the entire organisation to be able to use it and add data to the SP List, without being able to go into the List directly and make changes to the list itself. So that changes to data only happen in the List.

Was this reply helpful? Yes No
WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KGee1 ,

You need to share the SharePoint list with the organisation. This can be tricky if it the site it is in has some restrictions (which I suspect it has from the message you are getting- I have found you can restrict permissions at list level, but not expand them).

If this is the case, either share the site with everyone or add a sub-site, put the list in there (you will need to make a copy) and then share the sub-site with everyone.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No