Patching Powerapp to Sharepoint List anonymously

Copper Contributor

I've built a powerapp that patches data into a sharepoint list. 

I want to offer the ability for users to stay anonymous, and can achieve this on the front end with no problems. However, the sharepoint list tracks who created the entry in the list. So, if you go to the row details, you can see who created it.

 

Is there any way I can either turn off this tracking or prevent that information from being passed from the powerapp?

 

3 Replies
Hi!
You can do this by calling a Flow and create a listitem via that, as long as the flow runs in the context of another account it can be "anonymous" by enabling sure input.

@barryjarvis You cannot achieve this using only PATCH function in power apps. You have below options:

  1. Pass data from Power apps to power automate flow and use the power automate flow with service account (admin) account to create items in SharePoint lists
  2. If you are using complex data in power apps and unable to pass it all to power automate or facing any issue: You can copy the item from the current list after PATCH and add it to another list using power automate flow as given in this thread.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@barryjarvis 

You will need to use a Power Automate flow that performs a "Send an HTTP Request to SharePoint" Action to the url

_api/web/lists/getbytitle('list name')/items(<itemid>)/validateUpdateListItem 


using this body

{ 

  "formValues": [
                   {
                     "FieldName":"Title",
                     "FieldValue":"my new Title"
                   },
                   {
                     "FieldName":"MyOtherField",
                     "FieldValue":"mynewValue"
                   }
                ], 
  "bNewDocumentUpdate":true 

} 

You will have so specify which fields to set in the json array

https://www.concurrency.com/blog/may-2022/performing-a-system-update-of-a-sharepoint-list-item-throu...
https://techcommunity.microsoft.com/t5/microsoft-sharepoint-blog/update-file-metadata-with-rest-api-...