cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Collect answers from users without giving them writing access to sharepoint

Hello everyone,

 

I am new on powerapps and created a survey app that I want to share with the rest of my company and get the results from the users.

However I can't seem to find how to collect the results of the users on a sharepoint list ou Excel file without giving them writing access (which would be a security problem as they could have access to the results of others and modify other parts of the sharepoint)

 

Is there a way to do it ? 

 

Thanks !

 

Baudouin

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Collect answers from users without giving them writing access to sharepoint

Yep--create a new list and share only that list with users

https://www.youtube.com/watch?v=q8iHJy_6dlI&t=5s

 

then have the flow create the item in the master list

 

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: Collect answers from users without giving them writing access to sharepoint

No reason you have to have the app write directly to the primary sharepoint list. Create a list that the app writes to as a staging list, then have an automated flow owned by a system admin that runs when an item is created in that list and write it to list B. You could then have the flow delete the item from list A.

 

that way the user can submit an answer but not have direct access to the primary list

 

@Baudouin  if this answers your question please mark it a solution.

Highlighted
New Member

Re: Collect answers from users without giving them writing access to sharepoint

Thank you for your quick reply, I will try it and see if it works !

 

Just to be sure I would have to create an entirely new sharepoint for the stagging list or is it possible to only give writing access to a specific list on a sharepoint but not to the rest of it ? 

 

Thanks

Highlighted
Super User III
Super User III

Re: Collect answers from users without giving them writing access to sharepoint

Yep--create a new list and share only that list with users

https://www.youtube.com/watch?v=q8iHJy_6dlI&t=5s

 

then have the flow create the item in the master list

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,904)