User Information List Data Won't Populate into InfoPath Form While Also Preserving Original Data

Hello,

I am trying to use the User Information List and have been following these directions:  User Information within InfoPath Forms. The only difference is I am setting the default value for some of the InfoPath fields to the UIL data values rather than just dragging the UIL data fields onto the form.  It works wonderfully except that it always populates the fields with data from the current user and I need the data from the original user to remain in the list, even when the list item is reopened.  If I uncheck "Refresh value when formula is recalculated" under "Text box properties" then the original data stays in the list.  However, when adding a new record the fields that get their default values from the UIL data fields are now empty.

I tried using the User Profile Service (UPS), which works in InfoPath, but there appears to be a network or server security setting that is causing the dreaded "5566" error when the form is opened in the browser. 

Does anyone have a solution on how I can pull the UIL data on new records AND still keep the original users profile information in existing records when they are reopened?  Thanks in advance.

Ken

September 11th, 2015 12:25pm

While prefilling the data to field, write a condition to check if it is empty. That way you can prevent data being overwritten when some one else is viewing the form.

Prefill data only if the field is empty!

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 2:35pm

Thanks for the quick reply.  That is not working for me.  I have the following condition:

Field1 is blank or
Field2 is blank or
Field3 is blank or
Field4 is blank or
Field5 is blank

I doesn't work with "and" either.  I'm using the data field under the "Main" data source for the fields.

Ken

September 11th, 2015 2:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics