cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rang
Regular Visitor

Is it possible to create SharePoint list item on behalf of 1 user/account on PowerApps?

 Scenario:

  1. Built an app (using PowerApps) that basically just adds entries to a SharePoint list.
    • this results to entries in SharePoint with "Created by" whoever used the app - that is ok since they all have access to this SharePoint
  2. Now we are moving the said SharePoint into a restricted space and the plan is to grant access to an account that will be used by the app to create entries in the ShrePoint list. Is this possible? So the idea is people will have access to the app but once they hit "Submit" in the form, powerapps will then add entries to the SharePoint but this time using the assigned account which has access to the said SharePoint.

To explain further:

A. Previous scenario (UserA has full access to SharePoint list):

  1. UserA uses the app to submit form.
  2. PowerApps create an entry on the SharePoint. SharePoint entry has "Created by" UserA

B. Plan scenario (UserA has no access to SharePoint list. SuperUserA has access to SharePoint list)

  1. UserA uses the app to submit form
  2. PowerApps creates an entry on SP on behalf of SuperUserA. (since UserA doesn't have direct access to the SharePoint)

PowerApps form does not need to display/edit entries. It's all about adding an entry to the SharePoint list. Is Plan Scenario B possible? If not, what could be a workaround? Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
RoryL
Community Support
Community Support

 

Hi rang,


Thank you for your post. In the context of a Power Apps canvas app, the user will need direct access to the SharePoint data source through their user account by utilizing the connection within the app.

 

One potential workaround would be to have the App call a Team Flow which utilizes the a shared connection which has access to the SharePoint list to make the update on behalf of the user.

 

More information about how to connect a Canvas App to a Flow is available here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

 

More information about how to create and share a Team Flow is available here: https://docs.microsoft.com/en-us/power-automate/create-team-flows

 

I hope this helps.


Thank you,

Rory

View solution in original post

2 REPLIES 2
RoryL
Community Support
Community Support

 

Hi rang,


Thank you for your post. In the context of a Power Apps canvas app, the user will need direct access to the SharePoint data source through their user account by utilizing the connection within the app.

 

One potential workaround would be to have the App call a Team Flow which utilizes the a shared connection which has access to the SharePoint list to make the update on behalf of the user.

 

More information about how to connect a Canvas App to a Flow is available here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

 

More information about how to create and share a Team Flow is available here: https://docs.microsoft.com/en-us/power-automate/create-team-flows

 

I hope this helps.


Thank you,

Rory

rang
Regular Visitor

I haven't actually tried this but sounds like this is the solution. Thanks!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,794)