General

Re: Results from GetUserProfilebyName Connection not showing when form published

darrenfloyd666 — Tue, 06 Feb 2018 16:05:22 GMT

Thanks Hilary, I'll give it a spin!

Re: Results from GetUserProfilebyName Connection not showing when form published

Hilary Stoupa — Tue, 06 Feb 2018 15:58:00 GMT

I added a rule to first set the account name to the user name prior to running the query. I've also added the query field, a button to run the query, and the data fields on the form to help you troubleshoot. So - if you are using claims auth, there is a chance you'll need to remove some characters from the user name prior to setting the account field, but this at least lets you see what's happening, and you can try different values in the account id field without having to republish the form to test.

Re: Results from GetUserProfilebyName Connection not showing when form published

darrenfloyd666 — Tue, 06 Feb 2018 15:49:05 GMT

Yes, those are the results I'm getting back in the browser and it's on the Form Load rule. I've attached the form.

Re: Results from GetUserProfilebyName Connection not showing when form published

Hilary Stoupa — Tue, 06 Feb 2018 15:36:59 GMT

Not really. The data fields from GetUserProfileByName usually have a name and a repeating value. Are you telling me those are the values you are getting back in the browser? If so - are you running the data connection on load of the form? Or are you setting the account id query field to the current user name and running it? The CN looks like a service account of some kind.

Re: Results from GetUserProfilebyName Connection not showing when form published

darrenfloyd666 — Tue, 06 Feb 2018 10:06:13 GMT

It's worth saying that when I use the GetUserProfilebyName with the People Picker on a form on the same site it works fine. Just on this form I want to automatically populate the Manager field and it isn't.

Re: Results from GetUserProfilebyName Connection not showing when form published

darrenfloyd666 — Tue, 06 Feb 2018 09:41:13 GMT

Thanks. The results I'm getting back are:

\sp-prd-portalap

\SP-PRD-PortalAP

\sp-prd-portalap

CN=SP-PRD-PortalAP,OU=SP-PRD,OU=SharePoint,OU=Administration,DC=xxx=xxx

Does that make any sense?

Re: Results from GetUserProfilebyName Connection not showing when form published

Hilary Stoupa — Mon, 05 Feb 2018 17:47:48 GMT

I'm assuming this is in the browser. Sometimes fields present in the Filler (Preview) in InfoPath have different names or aren't present in the browser. Drag the data fields for the connection onto the form and republish so you can see what's going on.

Results from GetUserProfilebyName Connection not showing when form published

darrenfloyd666 — Mon, 05 Feb 2018 11:54:51 GMT

I've got an InfoPath 2010 Web Browser Form where I have a field where it's successfully returning my manager's name on preview. However when I publish it the form fails to display the Managers name? Any idea what's happening? Any help really appreciated!