Data Connections

Re: Lookup Data in second list from a form in an anonymous list

mattpalmgren — Tue, 14 Feb 2017 17:38:57 GMT

Thanks so much Hilary. Yes I created a UDCX connection using secure store. I am getting a 5566 error :(

Re: Lookup Data in second list from a form in an anonymous list

Hilary Stoupa — Tue, 14 Feb 2017 16:54:09 GMT

Did you try already w/ a UDCX using secure store? The reason I hadn't answered this is because w/out trying, I would only be guessing. :)

Re: Lookup Data in second list from a form in an anonymous list

Sanders_wa — Mon, 13 Feb 2017 23:33:13 GMT

I'm also looking to do something very similar but have found no solutions. Looking forward to seeing any suggestions on how or if this is possible within an InfoPath form.

Lookup Data in second list from a form in an anonymous list

mattpalmgren — Wed, 08 Feb 2017 21:04:58 GMT

I have two lists (not forms libraries). List 1 contains information about people (Full Name, Employee ID, and Phone Number) and can only be accessed when logged in. List 2 contains information about training requests (Training Requested, Requested Session Date, Employee ID, and Phone Number) and is accessed anonymously. I would like a user to go to List 2 and create a new item. They would enter in the Training they would like to take, enter the date they want to take it, and enter their Employee ID. When they submit the form, I want the form to grab the Employee ID they entered, look for it in List 1, and if it is found, grab the user's phone number from List 1, and enter it in the Phone Number field on the form. So it is like an Excel vlookup from an anonymous list to a secure list. Is there a way to do this using Secure Store? Thanks!