SharePoint Integration

Re: Set Person Picker as Previous Section Value

Trapperj — Sun, 09 Sep 2018 15:04:28 GMT

Darn. Oh well, thanks Hilary, i appreciate the reply

Cheers

Re: Set Person Picker as Previous Section Value

Hilary Stoupa — Wed, 05 Sep 2018 20:28:47 GMT

So - I'm pretty sure this isn't possible with rules. When you add additional people, the schema inserts a new repeating pc:Person node (see attached screenshot). We can't use rules to copy repeating data in InfoPath. You have a list form, so you can't use code for this either, I'm afraid.

Re: Set Person Picker as Previous Section Value

Trapperj — Mon, 03 Sep 2018 17:45:56 GMT

Re: Set Person Picker as Previous Section Value

Trapperj — Mon, 03 Sep 2018 17:44:57 GMT

another image attached

Re: Set Person Picker as Previous Section Value

Trapperj — Mon, 03 Sep 2018 17:44:24 GMT

images attached

Re: Set Person Picker as Previous Section Value

Trapperj — Mon, 03 Sep 2018 17:43:11 GMT

Hi Everyone,

Apologies for resurrecting this thread, but I have been trying to use this formula myself, however my case is slightly different. I'm trying to get the people picker to copy over multiple users when a section is added. I have used the formula provide, but it only copies over the first name in the people picker (i have set the picker for multiple selections, and ensured the corresponding column in SharePoint list is set for multiple users.

However, no matter how many names i type in the People picker and then verify with the tick, when i add a section, only the first name carries over. See attached images. I've attached my testing form too.

Can anyone tell me where i'm going wrong with the code?

This gentleman has been having the same problem

http://www.infopathdev.com/forums/t/38682.aspx

I am using Infopath 2013 in SharePoint on Premises 2013

any help greatly appreciated

Re: Set Person Picker as Previous Section Value

Joe_AUT — Sat, 01 Jul 2017 14:54:12 GMT

Sorry, I didn't find any time until now to complete the form. Your solution works perfectly now! Thank you so much Hilary. Really appreciate it.

Re: Set Person Picker as Previous Section Value

Hilary Stoupa — Tue, 27 Jun 2017 21:55:07 GMT

Got it - yep, same thing happens on mine. So - here's what worked for me. On the rule on the repeating group (my:SharePointListItem_RW), add a condition to only run the rule if the DisplayName field is blank. I think when the form loads in the browser to edit, the rules on the repeating group are executing, setting the first instance to blank, which then impacts the following instances.

Re: Set Person Picker as Previous Section Value

Joe_AUT — Tue, 27 Jun 2017 08:44:35 GMT

exactly. When I'm editing an existing item, the people picker is blank and I need to re-enter the name...

Re: Set Person Picker as Previous Section Value

Hilary Stoupa — Mon, 26 Jun 2017 15:02:02 GMT

So - you are saying when you re-open an existing item to edit, the people picker appears blank? Or am I misunderstanding? I want to see if the same issue exists in my test form - for some reason I have a vague recollection of something similar with InfoPath Browser forms (not just list forms).

Re: Set Person Picker as Previous Section Value

Joe_AUT — Mon, 26 Jun 2017 12:40:17 GMT

It works! Thank you so much for finding a solution, Hilary. There's only one new issue now: With the added rule, every time I'm editing an existing record the name field is emptied when the form is loading. I've changed the formulas to

preceding-sibling::my:SharePointListItem_RW[1]/my:Name/pc:Person/pc:DisplayName
preceding-sibling::my:SharePointListItem_RW[1]/my:Name/pc:Person/pc:AccountId
preceding-sibling::my:SharePointListItem_RW[1]/my:Name/pc:Person/pc:AccountName

but this also doesn't solve the issue... any more ideas?

Re: Set Person Picker as Previous Section Value

Hilary Stoupa — Thu, 22 Jun 2017 16:51:39 GMT

I found the problem! Incorrect XPath - there was an "@" in front of the people picker fields that did not belong there. Try attached copy.

Re: Set Person Picker as Previous Section Value

Joe_AUT — Thu, 22 Jun 2017 13:32:27 GMT

Still can't get it to work unfortunately. I'll keep on trying and will post my feedback in case I've found a solution! As always, thanks a lot for the effort.

Re: Set Person Picker as Previous Section Value

Hilary Stoupa — Wed, 21 Jun 2017 23:21:29 GMT

Maybe try removing the index ([1]) from the formulas. I just created a test form on one of my SharePoint sites for a list there and this worked as anticipated. It also worked in preview....

Re: Set Person Picker as Previous Section Value

Joe_AUT — Wed, 21 Jun 2017 21:29:17 GMT

I still can't get it to work, tried to play around with the formulas a bit but there's still no result. Thanks a lot for the effort tho - really appreciate it. Until now I didn't know about the functionality to add rules to new sections, so it wasn't for nothing... I learned something new at least :-)