Comments (40)

  1. Anonymous says:

    Hi can it implement in infopath, like i want to display the list items in infopath itself. if i select emp id, should display automatically all the info related that employee in infopath itself.

  2. Anonymous says:

    I have the same question as m.Riston from 29 Jul 2013 5:48 PM:

    "Is it possible to pull in the, say ‘Title’ field of another user that is determined based off of a people picker? Say I’m trying to create a form that I’m selecting someone’s new supervisor and I want to populate that user’s ‘Title’ or ‘WorkPhone’ field after
    I select it using a people picker. Is that possible?"

    https://social.technet.microsoft.com/Forums/en-US/1e4117d2-652b-442c-9ff1-2153eeedde69/how-to-get-user-profile-service-information-on-user-other-than-current-user?forum=sharepointcustomization

  3. Anonymous says:

    how to change the Form Load rule's condition to DisplayName is blank? I can only see the AccountName. Thank you

  4. Anonymous says:

    Is it possible to pull in the, say 'Title' field of another user that is determined based off of a people picker? Say I'm trying to create a form that I'm selecting someone's new supervisor and I want to populate that user's 'Title' or 'WorkPhone' field after I select it using a people picker. Is that possible?

  5. Anonymous says:

    whenever the form is opened again either to view or edit, it displays the current users information instead of the value of the person who completed the form in the first place. please help

  6. Anonymous says:

    Hi Jason – I had forgotten I had that problem, too. Change the Form Load rule's condition to DisplayName is blank and that should work.

  7. Jason says:

    Firstly thanks for the information. It works great. However i have an issue whenever the form is opened again either to view or edit, it displays the current users information instead of the value of the person who completed the form in the first place.

    Any feedback would be appreciated.

  8. Andrew Brooks says:

    Hi, thanks for pointing me in the right direction on this.  I was going around in ever-decreasing circles.  However, it's a case of one-step forward, two back at the moment!  I can preview the form, and everything is fine, i.e. my form is populated with user data and manager data, as expected, but as soon as I publish to the SP Server, I get the following error on running the form.  

    An error occurred querying a data source.

    Click OK to resume filling out the form. You may want to check your form data for errors.

    Show error details

    I am a Farm Administrator, so jsut wondered if you had any ideas what is going on.  If I click on OK, the form appears, BUT none of the data is populated as it is in preview.  

    HELP!  Thanks

  9. Marie says:

    Hello,

    Thank you for this fabulous tutorial, it's really helped me out!

    I just have one question, as per the diagram (blogs.technet.com/…/5127.RemainingRules.jpg )

    I want the managers email being pulled through, but I can't seem to get it? I see a new query has been added with GetUserProfileName but that just autopopulated the manager field with my own email address.

    Any help is much appreciated!

  10. fbfdbh says:

    Firstly thanks for the information. It works great. However i have an issue whenever the form is opened again either to view or edit, it displays the current users information instead of the value of the person who completed the form in the first place.

  11. Balaji says:

    Hi,

     Thanks for the article and it is very useful information. I am having the issue that the look up field has to load more than 5000 records and it takes more time to load the form and sometimes it is loading the partial data. Is it anyway to modify the query or need to do something to fix the issue?

  12. James says:

    Really good, works perfect first time (even though I have no idea what I have actually done).

  13. V Prasanna rani says:

    Thank u…Very usful

  14. Navoneel says:

    very nice ..very helpful.

  15. Wilson says:

    Follow the steps and no value to populate in preview. Any idea?

  16. Curt Hasan says:

    I new to this and I've already created a form in InfoPath and connected it to the forms library.  I have several fields that I want to auto-populate.  Where do I start use the information provided?

  17. Chad Covington says:

    Im trying to create a form in which the intial form is create but then I want to create a workflow inwhich the form is sumitted and then a nother form within the worklfow appears and the information that was in the previous form appears in the secondary form. Is this posisble?

  18. Patric says:

    Thanks Anne!

    Here's a related post on InfoPath 2010 Best Practice Querying User Profile Web Service:

    http://www.sharepointbreak.com/…/infopath-2010-best-practice-querying-user-profile-web-service

  19. KP says:

    Hi Anne,

    Great article.

    Would you know how to get the Full Name (First and Last Name) of the Manager. In your example I can see that you're getting the Manager field as domainuserid. I'm looking for a way to get the first and last name.

    Any help is much appreciated.

    Thanks,

    KP

  20. Simi says:

    Thank You. Really Useful

  21. Vidyashree R says:

    user profile values are not populating in the infopath form after publishing it to sharepoint 2010.
    Please let me know where i am going wrong.

  22. Liz Chan says:

    Instead of using accountName as blank, i used another field that I know was going to be blank until the user filed it out. So mine was SiteURL is Blank. Thank my actions were query by GetUserProfile and Set data fields.

  23. Pete says:

    Will this work with anonymous access enabled on the server?

  24. Sophia says:

    Nice its very helpful

  25. Nanda says:

    Nice article. I can get the User Name in the preview, but I am getting an error after publishing. Help me please.

  26. Nat says:

    Thanks so much for this information. I have been working on getting this completed for over two weeks now. The form populates only my name on the field, not the person who submitted the form. I’ve tried several ways to set up rules for this but the result
    is always my own name showing up on the form. Is there anything that I should be doing differently? your help is greatly appreciated 🙂

  27. Rashmi says:

    very helpful

  28. Sreelatha Muntimadugu says:

    Thank you for your detail post. I could implement this easily with your fabulous screenshots

  29. Gerardo says:

    One question, this works for Sharepoint online too?

  30. RP says:

    I’m having the same problem as Andrew Brooks above – was there an easy fix?

  31. Mini says:

    I have the same question as Steven Norman – "Is it possible to pull in the, say ‘Title’ field of another user that is determined based off of a people picker? Say I’m trying to create a form that I’m selecting someone’s new supervisor and I want to populate
    that user’s ‘Title’ or ‘WorkPhone’ field after I select it using a people picker. Is that possible?"

  32. Ritesh says:

    Hi, I did this in the server environment, but is it possible for SharePoint 2013 online also, where we work on cloud ??

  33. Rob says:

    Awesome….configured Profile Service to pull more data from AD. Worked like a charm. Great work.

  34. Veera_B says:

    HI Anne and All,

    Iam newbie to Infopath, current iam working on infopath office 365 form. Our app is used to save first name, Last name…Status field values into Sharepoint list …so far every thing is fine. Now if any one click on Users First Name…A new form is open and
    display all saved vales of that user…How to proceed onthis…your help is very much needed..Thanks In advance…

    Do the needful

  35. Kevin Doherty says:

    First of all thank you for such a comprehensive set of instructions. I too am having the same problem as Andrew Brooks, everything is working perfectly until i publish to SharePoint and then i get the error "An error occurred while trying to connect to
    a Web service."

    Does anyone know why this may be happening and what i need to do to fix?

  36. Tolga says:

    Thank you very much Anne, great information.
    I’m trying to implement what you wrote in Sharepoint 2013 environment. I select the user from the AD but the query rules do not work and cause Infopath to crash. Although very unlikely, is it possible that Name="Department" syntax has changed in SP 2013?
    Thanks,
    Tolga

  37. Valdo says:

    Hi, Im new in infopath and sharepoint, but i have create a form in infopath to auto populate user information and i convert the connection and all things good, but when users create form the sharepoint doesn’t keep the user information and when other user
    open the same form it the current user information…..And i don’t want it because i need workflow??Please need help

  38. Colton says:

    Thank you for this superb guide!

  39. Ed Carter says:

    Like – Kevin Doherty 3 Jul 2015 1:17 PM — First of all thank you for such a comprehensive set of instructions. I too am having the same problem as Andrew Brooks, everything is working perfectly until i publish to SharePoint and then i get the error "An
    error occurred while trying to connect to a Web service." Does anyone know why this may be happening and what i need to do to fix?

    I have now recreated similar info that would be found in the UserProfileService by putting this information in a list. Problem is I cannot figure out how to pull the data from the different columns. So far my workaround is at a dead-end. -Edward.compudoc@gmail.com

  40. BlueSky2010 says:

    Great article – thanks!