Sharepoint Get Items Action run as service account

[alex5p]

I am currently using the Sharepoint Get Items action within one of my flows. It has been working for over 5 + years however, due to security reasons at my current company they have removed access to Sharepoint for all users. Because sharepoint has been disabled for all users the flow is failing out whenever someone tries to run it. Is it possible to have the "get items" action run as a service account that created the flow rather than the user who is triggering the flow? 

[v-bofeng-msft · Accepted solution]

Hi @alex5p ,

If this flow is a 'button flow' , you could try:

1. On the details page of the flow, click the "Edit" button next to "Run only users":

2. On the "Manage run-only permissions" panel, make sure to select "Use this connection (...)"(use your credentials) from the "Connection Used" dropdown list.

Best Regards,

Bof

[paulbeck1]

@alex5p check who the flow runs as, the user/users need access to the SPO list.

[alex5p]

@v-bofeng-msft @paulbeck1 Thanks for your responses.

Sorry I should have added a little more detail. I have a button setup in a powerapps application that runs the flow. The flow is type "instant". I am not seeing that option to  "run only user". This flow was created about 4 years ago as well. There is a Connections menu like you have in the screen which is set to a service account that doesn't have sharepoint blocked. If I login as the service account onto the powerapps application and hit the button to run the flow it works fine. 

[paulbeck1]

@alex5p So you are running an Instant flow and the trigger is Power Apps. 

By default this flow runs in the context of the user that is logged in in the Canvas App and triggers the flow.  You can specify the account to use.  There should also be an option to buy pay-as-you-go flows and then you can just pay for the flows you use.

[paulbeck1]

@alex5p try rebuild the flow if it is easy/simple, use the copy action option to add actions 1 step at a time.