InfoPath 2010 for SharePoint 2010 List Form

Hi,

Again i have been off for few days from my blog, now i am here writing about a coolest feature of InfoPath 2010 for SharePoint 2010. That is creating SharePoint List Form. In Simple word to modify the new item form on the List.

So the ingridents are,

1. InfoPath 2010

2. SharePoint 2010 running somewhere on your domain.

and the Recipe is

Create a List named as Today Sale, I want some changes in its item creation form,

now open InfoPath 2010, Select SharePoint List in the Popular Form Templates



next in the Data Connection Wizard, provide the path of site in my case it is http://sp2010/, in the next step choose Today Sale in the Customize an existing SharePoint List

click finish to end this wizard.

Form open in the below  format .

now we have to bind the Current User Username with the title, so first you have to make a Data Connection which fetch the details of current user.

In the Infopath Ribbon select Data, choose Data connection, click on Add

Click on the Receive data as done  in the above .

Select SOAP Web Service as done in the above click next, in the next step, provide the path SOAP Web Service of UserProfile, it resides at  http://ServerName/_vti_bin/UserProfileService.asmx. Then Click Next.

Choose the operation GetUserProfileByName as it is done in the above picture.  Click Next on following screen as well and then click finish to end this wizard.

Now then,  it is time to add the essential ingredient, bind the field with the current user info.

Right click on the Title field, go in to the text box property, click on fx as in the below picture

Click on the insert Field or group

Click on advance view in the Select a Field or Group.  Now in the Fields drop down select GetUserProfileByName. expand the below tree and select value as it is done in the below picture,

click on the Filter Datat after selecting Value.

now Click add to add a filter. In order to specify the filter condition, choose the Select Field or Group

Choose Name under the Property Data, as it is done below

and then click OK.

now back on the Specify Filter Condition dialogue Box, Expand  the third drop down list  and Select Type Text. This Drop down now act as Text Field, now a very important note here your have to provide the require profile property in my i want username so  enter UserName (Case Sensitive ) in the Text Field. Now Click Ok 5 times to close all the boxes 🙂

now we are back on the form, let’s do some garnishing on this form 😀

Delete the 2nd row of attachment as i dont want this, now you can preview the form.

I guess now it looks fine to me, so publish it right away.  Now go onto your Today Sale list  in your SharePoint site and click on the

add new item. you will get the following screen.

To end it on a learning note, below are the profile properties,

UserProfile_GUID
AccountName
FirstName
LastName
PreferredName
WorkPhone
Office
Department
Title
Manager
AboutMe
PersonalSpace
PictureURL
UserName
QuickLinks
WebSite
PublicSiteRedirect
SPS-Dotted-line
SPS-Peers
SPS-Responsibility
SPS-Skills
SPS-PastProjects
SPS-Interests
SPS-School
SPS-SipAddress
SPS-Birthday
SPS-MySiteUpgrade
SPS-DontSuggestList
SPS-ProxyAddresses
SPS-HireDate
SPS-LastColleagueAdded
SPS-OWAUrl
SPS-ResourceAccountName
SPS-MasterAccountName
Assistant
WorkEmail
CellPhone
Fax
HomePhone

have a nice week-end, and happy coding and Sharepointing 😀

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 )

Facebook photo

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

Connecting to %s