Qdabra qRules

Re: How to map person/group picker

ssvs187 — Thu, 26 Sep 2013 19:16:16 GMT

You are Simply Awesome!!!

Re: How to map person/group picker

ThomasV — Tue, 11 Dec 2012 12:10:51 GMT

Thanks,

but what I was looking for was to set the value of the people picker. I can get the emails out of the people picker, that is not a problem.

In my scenario I get some persons out of a person picker of a settings SharePoint list. Then I want to set these persons as value of the person picker in IP when a new form is opened.

Re: How to map person/group picker

jerryO — Mon, 10 Dec 2012 13:01:13 GMT

I normally create a concat names field that sets the People Picker values to a regular text field. If you are using claims based authentication, the email addresses are not formatted in a simple name@domain.com. The email addresses are formatted liked " i:0#.f|membership|name@domain.com.

Create a text field that will be used to concatentate the names that are entered into the People Picker. Have a rule that sets the fields value each time the people picker is changed. You will need to strip off the beginning part of the email address and add a semi-colon in between each name. The code would look something like this:

xdMath:Eval(xdMath:Eval(../my:group/pc:Person, 'concat( substring-after( *[local-name() = "AccountId"], " i:0#.f|membership|"), ";")'), "..")

You can promote this field and use it for sending purposes.

BTW, you cannot enter groups in the People Picker field using this method.

Re: How to map person/group picker

ThomasV — Mon, 10 Dec 2012 07:21:57 GMT

Oh, sorry.

I was trying to set a default value of a person picker. The defaults are configured in a SharePoint list using a person/group picker. That's no problem.

On my IP form I was using double eval to get the persons preconfigured.

When only one person is set in the list, all works fine. As soon as more persons are configured in the list and I set the value of the picker in IP like this: "AccountId1;AccountId2"
The person picker shows the correct persons and clicking the "Check Names" button works without any error.
The problem is, that the form can not be submitted because it reports errors on the form.

I checked the XML and I think the problem is that my code sets the value of only one person and I found no solution to add a second, third, .. person in the picker using some code, rule, ...

Do you have an idea how this scenario can be supported?
Thanks

Re: How to map person/group picker

Hilary Stoupa — Thu, 06 Dec 2012 15:01:08 GMT

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?

Re: How to map person/group picker

ThomasV — Thu, 06 Dec 2012 09:51:01 GMT

No.

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

Re: How to map person/group picker

Hilary Stoupa — Wed, 05 Dec 2012 23:28:30 GMT

You are using qRules?

Re: How to map person/group picker

ThomasV — Wed, 05 Dec 2012 07:19:28 GMT

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.

Re: How to map person/group picker

Hilary Stoupa — Thu, 06 Sep 2012 18:40:18 GMT

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

Re: How to map person/group picker

jerryO — Thu, 06 Sep 2012 18:29:04 GMT

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.

Re: How to map person/group picker

Hilary Stoupa — Thu, 06 Sep 2012 18:14:28 GMT

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?

Re: How to map person/group picker

jerryO — Thu, 06 Sep 2012 17:35:33 GMT

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?

Re: How to map person/group picker

wkargo — Wed, 04 Jul 2012 11:34:32 GMT

Thanks Hilary

It works like a charm .

Re: How to map person/group picker

Hilary Stoupa — Tue, 03 Jul 2012 22:46:32 GMT

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.

EDITED:

So, I just was using this post as reference - for Filler w/ O365, it is the -1;# with substring after membership|. For browser, you need the full thing - -1;#i:0#.f|membership|email@email.com

Re: How to map person/group picker

Hilary Stoupa — Tue, 03 Jul 2012 22:07:47 GMT

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....