cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Problem: PowerApp does not save values in on premises SharePoint column of type Person

I just started to explore possibilities with PowerApps and I hope this issue is not already known.

 

My problem occurs with saving new item in column of type Person and on-premises installation with Data Gateway. Everything looks great in PowerApp, Person field is correctly populated, data are selected and visible and all other columns are also saved correctly. Only Person column is missing after save in Sharepoint List.

 

Similar scenario works fine with Sharepoint online therefore I suspect that something must be wrong in Data Gateway. On Sharepoint server I found few suspicious messages where username is not transferred correctly. I can see missing \ and missing fist letter of the loginname. (0#.w...)

 

(in my case local Sharepoint is version 2013, on-premises data gateway is at version 16.0.4002.1211 and version of used client PowerApps is v. 2.0.574. SharePoint list locally works fine and even if I populate Person column locally in Sharepoint it is later visible in PowerApps )

 

EventID: agmjp

Process: w3wp.exe (0x1DF8)

Thread: 0x32F0

 

Original error: Microsoft.SharePoint.SPException:

The specified user i:

0#.w|domain oginname

could not be found.   

 at Microsoft.SharePoint.SPWeb.EnsureUser(String logonName)   

 at Microsoft.SharePoint.ServerStub.SPWebServerStub.InvokeMethod(Object target, String methodName, ClientValueCollection xmlargs, ProxyContext proxyContext, Boolean& isVoid)   

 at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, ClientValueCollection args, ProxyContext proxyContext, Boolean& isVoid)

  

I will appreciate any suggestion,  BR

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Problem: PowerApp does not save values in on premises SharePoint column of type Person

Hi @power2apps,

 

A fix for this issue is under the deployment during this week.

There might be some time delay (in a Week) before the fix reaches your region.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Problem: PowerApp does not save values in on premises SharePoint column of type Person

Hi @power2apps,

 

Thanks for reporting this.

I will forward this from my side, and post back if I got any response.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Community Support
Community Support

Re: Problem: PowerApp does not save values in on premises SharePoint column of type Person

Hi @power2apps,

 

A fix for this issue is under the deployment during this week.

There might be some time delay (in a Week) before the fix reaches your region.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Problem: PowerApp does not save values in on premises SharePoint column of type Person

Hi @v-micsh-msft,

 

It works now. I am not sure what exactly helped as I first updated client PowerApps on my iphonne now is at version 2.0.590. After only this update behaviour didn’t changed so I also reinstalled on-premises data gateway. In control panel it shows now version 14.16.6228.1. With those changes I can now open on client app Column of type “Person or Group” and chosen Person from client is saved back on SharePoint list.

 

Great work – continue with quick resolutions of open issues and PowerApps will shine in rapid implementations.

 

Regards.

Highlighted
New Member

Re: Problem: PowerApp does not save values in on premises SharePoint column of type Person

I have built an app with excel online and powerapps and when i add items from power apps it wont save on the excel file and it won't give an error, Please help

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,946)