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

[power2apps]

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

[v-micsh-msft]

Hi @power2apps,

Thanks for reporting this.

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

Regards

[v-micsh-msft · Accepted solution]

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

[power2apps]

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.

[prabuddha87]

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