Mapping InfoPath 2013 person/group picker to SharePoint person/group column using SubmitToSharePointList - InfoPath Dev
in

InfoPath Dev

Qdabra® DBXL

Use our Google Custom Search for best site search results.

Mapping InfoPath 2013 person/group picker to SharePoint person/group column using SubmitToSharePointList

Last post 02-26-2015 08:12 AM by Tyler Hyland. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-24-2015 01:50 PM

    Mapping InfoPath 2013 person/group picker to SharePoint person/group column using SubmitToSharePointList

    As you know, when you add a person/group picker control to an InfoPath 2013 form, a group is created in the main data source. I'm wanting to map this group to a person/group column in a SharePoint task list using SubmitToSharePoint. I followed the instructions outlined here http://goo.gl/dwJXds but the information about repeating group data doesn't seem to apply here because on the SharePoint side it's a single column. I've tried mapping the group in my InfoPath form's main data source to the SharePoint person/group column but when I publish the form and execute the SubmitToSharePointList command, the qRules Error field returns the following: "Error occurred adding a new item: Invalid data has been used to update the list item. The field you are trying to update may be read only."
    Filed under: ,
  • 02-24-2015 01:56 PM In reply to

    Re: Mapping InfoPath 2013 person/group picker to SharePoint person/group column using SubmitToSharePointList

    Hey, Tyler -

    http://www.infopathdev.com/blogs/hilary/archive/2013/01/17/qrules-submittosharepointlist-and-a-person-or-group-column-type.aspx has the syntax that we need to submit. We usually add a field to the schema and use a double eval to concat the person or group info from the form with the "-1".

    Here's a sample default value:

    substring(xdMath:Eval(xdMath:Eval(../pc:Person/pc:AccountId[. != ""], 'concat(";-1;#", .)'), ".."), 2)

    In this case, the field with the default value is at the same level as the pc:Person group. Then we map the field w/ this default to SharePoint.

    Hilary Stoupa

  • 02-26-2015 08:12 AM In reply to

    Re: Mapping InfoPath 2013 person/group picker to SharePoint person/group column using SubmitToSharePointList

    Perfect!
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.