InfoPath Dev

Hi everyone, got somewhat a bit of a complex issue and not sure how to resolve it. Was hoping someone could point me in the right direction

My situation is that I am using the GetUserProfileByName web service to populate submitting user details on a form. Works great and doing what it needs to do when a user submits a form. But I have noticed when the form has been submitted and is required to be approved, the web service changes the populated name to the user who is approving the form, not the one who initially submitted it.

So my question is, is it possible to to make the submitting user details static on the following approving form? I really cant use this function if it keeps on changing to whoever is approving the form.

Many thanks

 My guess here is that you are using a default value that uses your secondary data connection. And that the data connection queries on load, so it will always have the name of the person opening the form.

Instead, use a form load rule and add a condition to it so that the user details only get set the first time the form is open. Let's pretend you have a field in the main data source of your form called UserEmail. You could add a form load rule that checks to see if UserEmail is blank, and if it is, set the field to the value from the User Profile web service.... Does that make sense?

Hi again Hilary, our resident guru! :)

As guessed, yes I am using the default value and from here grabbing the secondary data source and filtering the values for the fields PreferredName, Title and WorkEmail.

Funny you mention the form load rule, I did initially had one when I was using the people picker control, but changed it to text boxes/default values option in design so disabled it.

I'll give it a crack and see how I go... 

Cheers

 As expected, you were right Hilary!

 Thank you once again!

 Do be very careful with default values - sometimes they are exactly what you want, sometimes not. For example, if you had an Invoice form with a secondary data connection that had items and their prices - if you use default values for price and the price changes - what happens when you re-open an old invoice? Most likely, the price gets updated to the latest info and now all of a sudden your invoice has inaccurate info - 'cause you didn't charge 16.19 for that item back when it was created. :)

Glad you have it sorted!