Get SharePoint data without the user’s permission in a PowerApp

Coffee PowerApp

PowerApps uses the rights of the user that started the PowerApp. And when the PowerApp loads it will ask the user for permission to use his account to connect to the different connections the PowerApp uses.

As an example, I created a PowerApp that retrieved and displayed different types of coffee from a SharePoint list. As soon as I share the PowerApp and open it with another user you get the following screen:

PowerApps asks the user for permission

To ensure that the user does not receive this message, I have found a workaround using Flow. You can call a Flow from PowerApps and get data back from it. If you simply call a Flow from PowerApps and read the SharePoint list from that Flow, you will still receive this message. But if you call a Flow from PowerApps that calls on a second Flow, you will not get that message.

PowerApps get SharePoint list data without users permission

You do have to split the data that you receive from Flow because it is a string. So just save the data into a string and split the string to save it into an array.

UpdateContext({strFlowReturn: Flow1.Run()});

Leave a Reply

Your email address will not be published.