cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dvdalen
Level: Powered On

Create app without user approval and permission

I'm creating an app that has a drop-down that needs to be filled with the items from a SharePoint list.

 

There are 2 requirements:

- The user that runs the app doesn't have the permission to read the sharepoint list

- The user must not be presented with any approval for permission when starting the powerapp

 

I thought the solution was to create a flow that reads the list. The flow is created by the service account user (that does have access to the list). And also the Powerapp is created with this user. But unfortunatly you do get the 'give permission' screen when opening the Powerapp if you use the 'Get items' action for SharePoint in the flow. 

 

Now I do have a functioning setup.

  • I've created a powerapp that runs flow 1.
  • Flow 1 triggers Flow 2.
  • Flow 2 reads the items from sharepoint and returns the data to Flow 1
  • Flow 1 returns this data to the powerapp.

It is functioning but it is not the best for the powerapp performance and the flow runs is times 2. 

 

Are there other solutions that I can consider?

1 REPLY 1
Super User
Super User

Re: Create app without user approval and permission

Given the current design that is about your only possible solution if you want to store the choices in SharePoint. PowerApps and (Flows started with a PowerApps button) run in the context of the PowerApps user. Flows started automatically run in the context of the user who created the Flow. So Flow 2 is running in a different context then Flow 1. So your workaround will work, but I agree its not a great solution. But right now its your only real option.

 

FYI, the user will still be prompted to approve the OAuth connection to run Flow 1.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

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

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 52 members 4,297 guests
Please welcome our newest community members: