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

Adding sharepoint list's item without viewing permission

Hello. I need to build a powerapp to store employees' comments in sharepoint list. I prepared an app with a ms flow which update list with a new item. I want to permit apps's user to add new item to sharepoint list but I don't want to give them possibility to view this list. How can I do it?

1 ACCEPTED SOLUTION

Accepted Solutions
SamPo
Power Participant
Power Participant

@kuchar71 Without giving them access to the list, the only way you can do it is by creating a sub-flow.

Basically you set it up like this: The app calls a flow which then has an HTTP call to an endpoint of another flow.

In this second flow you will create the calls to SharePoint.

 

The first flow will be run as the user (with their permissions) who is currently using the app but the second flow will be run with the account of whoever created the flow (assuming yours) therefore you only need to allow that user access to the list and not anyone else.

 

If this answer is helpful then please consider marking it as a solution to help other users in the future.

 

Sam

View solution in original post

3 REPLIES 3
CollabTechie
Responsive Resident
Responsive Resident

Hi @kuchar71 - I would recommend reading this from the wonderful @WonderLaura 

https://wonderlaura.com/2019/07/18/powerapps-as-a-front-end/

---------------------------------------------------------------------------------------
If my reply was helpful, please give a thumbs up or please accept as solution if this resolved your issue

SamPo
Power Participant
Power Participant

@kuchar71 Without giving them access to the list, the only way you can do it is by creating a sub-flow.

Basically you set it up like this: The app calls a flow which then has an HTTP call to an endpoint of another flow.

In this second flow you will create the calls to SharePoint.

 

The first flow will be run as the user (with their permissions) who is currently using the app but the second flow will be run with the account of whoever created the flow (assuming yours) therefore you only need to allow that user access to the list and not anyone else.

 

If this answer is helpful then please consider marking it as a solution to help other users in the future.

 

Sam

Thanks for your help! I've done it in similar way, but your solution sounds even better.

My version is:
I have two flows. The first one adds an item into "temporary" list which is available for all app's user. The second one I made on admin's sharepoint account and it launches when new item in temporary list is created and it adds new item into "real" list (which is available for specific users) and then removes the item from temporary list.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,314)