InfoPath Dev

 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.)

 

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.

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

 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?

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"]

 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!

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