Unanswered

Connect As not connecting as service account

(0) Share

Report

Posted on by Community Power Pla...

I've got an Excel step in my Power Automate Flow which accesses an Excel file on SharePoint and gets a row. I've changed the connection to use a service account so I don't have to grant everyone access to this document. However, when I call this flow within my PowerApp, it is still running as the user logged onto the PowerApp and consequently failing because they don't have access to the file.

Should this work? When the PowerApp starts they get asked to provide permissions to the Excel connector.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

When you call Power Automate flow from Power Apps it runs under the account using the Power Apps, so user who is running the power apps should have access to file.

Permission consent what power apps ask is on Excel connection not on the file.

Regards,

DS

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi Deepak, I found this article from 2019 which seems to say that you can suppress the request for the user to login for the connection. What I don't know is whether the integration with PowerApps prevents this from working.

https://spdeveloper.co.uk/blog/2019/02/27/bypass-powerapps-run-permissions/

Was this reply helpful? Yes No