InfoPath Dev

 Hi

I'm trying to map in the infopath 2010 using qRules the person/group picker to SharePoint Person or group column.

How to map such field to SP field ?

 

 

 

Thanks

Off hand, I think the account Id field would do it - since the person or group column will use that Id for the lookup.... but if that doesn't work when you submit, let me know, and I'll set up a test template and get you a more concrete answer.

 Hi Hilary

I've tried both, but without success always got error when tried to submit that .

Thanks

I'll check this out later today and get back to you - are you using SharePoint & IP 2010?

Okay, I was wrong, wrong, wrong.

The AccountId has info you'll need, however. You'll need to create another field, outside of the person picker group and set a default value on it:

concat("-1;#", AccountId)

Then map that field instead. We would generally submit the user's ID number (which I'd hoped was in the AccountID field), but if we don't know what that ID is, we can use:

-1;#UserName

With UserName as the account id.

Now, if your users can select multiple people, we'd need to also use either a double eval or the DelimitedList command to aggregate the values. Does that make sense?

Also - this is for SharePoint 2010, not Office 365. We are still trying to work out the syntax for that....

Well -- looks like Office 365 uses the same syntax, pretty much - it uses:

-1;#emailaddress

You can get the email address from the AccountID - it has a result that looks like this in O365:

i:0#.f|membership|email@email.com

So you could substring everything after membership| to get the email address.

 Thanks Hilary

 It works like a charm .

Hi Hilary,

 

I am using O365 and am trying to submit to sharepoint using qRules 4.2 and IP2010, I have a People Picker field in a repeating table along with some other fields and I have created a separate field named StudentName with the function -  concat("-1;#", substring-after(AccountId, "p|")).  The AccountID is the People Picker AccountID field.  I am mapping the StudentName field I created to a Person\Group column in Sharepoint.

 I am getting "

The operation failed because an unexpected error occurred. (Result Code: 0x80020005)" in the error field from qRules.  Did I miss something? 

No - that formula should be right (I actually just referred to this post yesterday for mapping a people picker!).

Do you have other Lookup or Choice columns in your list? What about Date Time?

I attached my template, I do have choice columns but have not had any issues using them in the past. I searched a lot of forums and they all pointed me to the people picker field. 

I actually was meaning in your list, not your form. Are any of your SharePoint List columns aside from the user a special type?

Hi Hilary,

How should the concated value look like?

When I set a single Person using the AccountId only it works. It does not work using -1;#AccountId.
I tried setting the value to -1;#AccountId1; -1;#AccountId2; but that does not work.

When I set the value to AccountId1; AccountId2; it works and "Check Names" succeeded. But when I want to submit the form it reports errors on the form (the person picker).

I am using InfoPath 2010 with SharePoint 2010.

You are using qRules?

No.

The policy only allows me to use out of the box IP and SharePoint features.

 

Okay - I was asking because you posted your question onto a thread about qRules, so I was confused as to what you need help with.The concat formula I'm talking about is for use with qRules mapping to a SharePoint List - what are you trying to do?