General

Re: Using the People Picker to populate InfoPath 2013 fields

KTerry — Sun, 26 Nov 2017 23:26:43 GMT

Hi Hilary - This is now working. Thanks to everyone on the thread for their help!

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Wed, 22 Nov 2017 08:55:22 GMT

Hilary! Would you believe that it works this morning? Seriously, I did copy the original formula and change it but was getting the error and the Xpath editor wouldn't pop up, now it does! Thanks for all your help! Couldn't have done it without you!

Re: Using the People Picker to populate InfoPath 2013 fields

Hilary Stoupa — Tue, 21 Nov 2017 21:02:19 GMT

I'm assuming that you haven't copied the original formula or used the formula builder to create this. :) Here's what the XPath should look like: xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/tns:GetUserProfileByNameResponse/tns:GetUserProfileByNameResult/tns:PropertyData/tns:Values/tns:ValueData/tns:Value[../../../tns:Name = "FirstName"]

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Tue, 21 Nov 2017 16:02:09 GMT

Sorry, last question. I try the formula Value[Name = "FirstName"] for he First Name field but I'm getting: 'Value/Name" does not point to a valid location path of a field or group?

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Tue, 21 Nov 2017 15:41:25 GMT

BOOM! That worked! Thanks Hilary you're a star!

Re: Using the People Picker to populate InfoPath 2013 fields

Hilary Stoupa — Tue, 21 Nov 2017 15:11:08 GMT

Do you see the difference in our formulas? In mine, I am selecting the value where the NAME = "Department". In yours, you have the "." notation shorthand, so you are selecting the value where the VALUE = "SPS-JobTitle" .... which, of course, it does not. :) Copy the formula used for department, create a new rule right after that one to set JobTitle, and paste in the same formula. Then select the "Edit XPath" checkbox and just change Department to SPS-JobTitle.

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Tue, 21 Nov 2017 09:52:29 GMT

Thanks Hilary. I don't know if I'm looking in the wrong place for the Rules, but I click on the SelectedAccount field, then Manage Rules. I see the action Set a fields value: Department. It gives me the formula: Value[Name = "Department"] when I try and replicate that for the Job Title field (Value[. = "SPS-JobTitle"]) I don't get any results retuned. What am I doing wrong? (I've also tried 'Value[Name="Title"] in the formula, but get an error.)

Re: Using the People Picker to populate InfoPath 2013 fields

KTerry — Mon, 20 Nov 2017 18:00:47 GMT

Hi Hilary - I have the same or similar issue. I'd like to upload my file to see if you can help. Thanks, Kellie

Re: Using the People Picker to populate InfoPath 2013 fields

Hilary Stoupa — Mon, 20 Nov 2017 15:54:54 GMT

I wouldn't use defaults for this. Just add rules to the same rule I added on your selected account field

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Mon, 20 Nov 2017 15:44:37 GMT

To populate the relent fields would it be a matter of adding the filter, so in the manner I've attached (although I've tried to filter the Job Title into the Department filed)

Re: Using the People Picker to populate InfoPath 2013 fields

Hilary Stoupa — Mon, 20 Nov 2017 15:40:41 GMT

Right, and you can copy the rule that sets the department field to set your other fields. You can see the filter syntax there - you select the value and then add a filter to make the name equal to whatever you are seeing in the Name column in that secondary data source on the form - that makes it easier to get the rules right. :)

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Mon, 20 Nov 2017 12:16:05 GMT

Great! Thanks Hilary. When I select a person it gives me a mass of info, which is superb, just need to filter the info into the relevant fields. The rules you set up are called Get User Info?

Re: Using the People Picker to populate InfoPath 2013 fields

Hilary Stoupa — Fri, 17 Nov 2017 18:22:11 GMT

See attached for some ideas. Save the attached file locally, right click & you can take a look at rules & preview. You had some defaults set that I didn't understand, so I removed those. I removed the form load rules too! I added a section on the form with the query & data fields for the user profile connection so you could try some stuff and see what's returned - just enter account IDs and click the button to see the data. Rules are on the SelectedAccount field. :)

Re: Using the People Picker to populate InfoPath 2013 fields

darrenfloyd666 — Fri, 17 Nov 2017 08:38:14 GMT

Thanks

Re: Using the People Picker to populate InfoPath 2013 fields

Hilary Stoupa — Thu, 16 Nov 2017 19:30:09 GMT

I'll try to take a look later today - but it may be tomorrow. :)