InfoPath People Picker –> SharePoint Column

Within InfoPath, the ability to easily add a “People Picker” control allows for an easy-to-use interface for users, with search, and other functionality as with a People Picker used within SharePoint.

The underlying data structure is a “pc: Person” node within the XML :

  • DisplayName
  • AccountId
  • AccountType

It would be great if this column/field could then be promoted to a SharePoint column – and then the data within the list/library can be filtered depending on the “current user”.

BUT – if you try this, you’ll get some strange results.   You CAN promote the column outside of InfoPath, but only simply data types (text field)

As the People Picker is a repeating section, you have the ‘function’ drop down also

clip_image002

Here’s what you get – for promoting the Account Id column :

clip_image002[6]

I’ve tried a few other ways, but :

  • You CAN’T promote the entire People Picker control
  • You CAN’T create a ‘People or Group’ field in the list – and then choose this column (mis-matched types)

Solution :

There *IS* a way to achieve this, making use of a Nintex Workflow for a quick data update.

  • Don’t promote the column out of the InfoPath form

clip_image002[13]

  • Create a custom column within the list/library, that will be updated by a workflow

clip_image002[11]

  • Create a Nintex Workflow for the library – and set it to run “on update”
  • Use a “Query XML” action to read the value from the InfoPath form –> Account Id

clip_image002[15]

  • Add an “Update Item” action to update the value back to the listitem (the newly added column)

clip_image002[17]

  • Fairly simple workflow – will only be a two step process

clip_image002[19]

  • Save and Publish the workflow
  • Don’t forget to set “Start when items are modified” = Yes

Quick Demo

When a user adds a form, or edits a form, the value within the People Picker will change.

The underlying workflow will then update the column – and you can use the [Me] keyword in SharePoint List Views – and/or filters – and users will be able to view “MY” workflows/forms.

Here’s the form – with the user chosen from Active Directory :

clip_image002[25]

And – after the workflow completes – the User Account field is populated :

clip_image002[23]

With that in place, you can have a filter like this :

clip_image002[27]

With a very simple data update, you CAN use an InfoPath people picker within a SharePoint list/library….

Good luck – hope that helps with your project/s.

Smile

Advertisements

4 thoughts on “InfoPath People Picker –> SharePoint Column

  1. http://cheapsoccercleatsnike.blogspot.com/ – cheap soccer cleats It doesnt have to be expensive and chalet or caravan holidays in the UK often come with a discount for group bookings Or perhaps a day trip to the capital city or, alternatively, the countryside, if the hustle and bustle of London doesnt appeal Anything that gives the day a sense of adventure and a bit of difference from any other day would mean a lot to the birthday boy or girl and will be remembered for a long time to come If you think a physical gift is something theyll enjoy then theres no reason not to put in the effort to make it as perfect as possible and finding the perfect 60th birthday gifts couldnt be easier with the ever-growing present buying options available on the internet Rather than scouting a dozen shops in town, there are thousands of websites online dedicated to finding the gift thats just right for your family or friends turning 60 http://freetiffanysupport.webstarts.com/ – nike free tiffany Research in different nations have shown which Urinary tract contamination among the seniors beyond manage, in their very own home and institutional treatment centers are in exposure to possible this pathological situation http://www.lebron10xbasketball.com.
    http://cheapsoccercleats.blinkweb.com/ – cheap soccer cleats Always read these guidelines on your first submission and make your own notes It would be a waste of time making submissions that are rejected because of some minor adjustment you didn’t know about or forgotGenerally you will be required to select a category or categories you want your article listed under This is a straightforward processSome directories eg Buzzle http://lebron9forsaleshoes.blogspot.com/ – lebron 9 for sale There is also SEO training courses offered online with downloadable SEO training material Most online SEO Training courses are self paced, so you can learn it at your own pace for a set price There are even some free courses offered online as wellMost of these courses teach the basics of SEO This includes: learning how to use link popularity, keyword usage, and marketing techniques that can work best with SEO.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s