cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaifAli
Helper III
Helper III

Connection Issues - Individual user authentication and access

Hi Team,

 

So I am new to Power apps and i'm creating an app which actually maps the inputs from the frontend with a backend file on One drive and then posts the mapped data to a REST API 

 

For this I'm using power apps in the front to capture the inputs from user and then using power automate to map the inputs and send it to a 3rd party REST API.

 

The issue is that the connector "One Drive" actually uses a service account credentials for authentication and the mappings are stored in an excel there which needs to be pulled. When I share this app with another user they are prompted to authenticate connections with their individual accounts. Now if they authenticate then the One drive connection would be their individual one drive which doesn't have the mappings file.

 

For Ex  as seen below : 

 

InkedMicrosoftTeams-image (24)_LI.jpg

 

For security concerns i can't share that mappings file to all the users using my power app. Its just a backend database used by the app.

 

Is there a way i can use my default service account to authenticate in the one drive ??

 

Thanks

4 REPLIES 4
BCLS776
Super User
Super User

Based on what you've shared, only half of your problem can be solved through Power Apps. One of the key features of the platform is that security is tied to the credentials of the user logged in to the app. So, if users need a certain file to use the app properly, then they need access to that file. This also means they can access the file directly if they go looking for it. There is no completely effective way to thwart that.

 

Instead of OneDrive, consider storing the file on Sharepoint, which is not segregated by users. The same file in a single location can be shared amongst your entire user group.

 

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

@BCLS776 Even if I store that file to Sharepoint i still need to provide access to it to the entire group, which is something i can't do

 

BCLS776
Super User
Super User


@SaifAli wrote:

Hi Team,

 

So I am new to Power apps and i'm creating an app which actually maps the inputs from the frontend with a backend file on One drive and then posts the mapped data to a REST API 

 

For this I'm using power apps in the front to capture the inputs from user and then using power automate to map the inputs and send it to a 3rd party REST API.

 

The issue is that the connector "One Drive" actually uses a service account credentials for authentication and the mappings are stored in an excel there which needs to be pulled. When I share this app with another user they are prompted to authenticate connections with their individual accounts. Now if they authenticate then the One drive connection would be their individual one drive which doesn't have the mappings file.

 

For Ex  as seen below : 

 

InkedMicrosoftTeams-image (24)_LI.jpg

 

For security concerns i can't share that mappings file to all the users using my power app. Its just a backend database used by the app.

 

Is there a way i can use my default service account to authenticate in the one drive ??

 

Thanks


Unfortunately, you will keep running into this problem. The file must be shared with the users for them to use it with the app.

 

Instead, are you able to hard code the info from the file into your app?

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

The last resort for me could be hardcoding the contents in the power automate flow itself as a JSON file and then parse it and create all the mappings there only.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (3,354)