VLOOKUP???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rchorner - 25 Jun 2005 00:41 GMT

Total newbie here, please excuse me. I've bound a drop down control in my
form to one of the fields in an external LIST within my sharepoint site that
has multiple columns of data. My question is: how can I automatically
populate other fields (read-only) on the form with other data elements
(columns) from the LIST?

If I were doing this in excel, I'd just do a VLOOKUP. Any ideas???

Reply to this Message

Bruce Anderson - 28 Jun 2005 05:45 GMT

What worked for me was to add an Expression Box control. The DataSource had
XPath:

xdXDocument:GetDOM("TestLookup")/ns1:myFields/ns1:entities/ns1:value[../ns1:key = current()/my:id]

I was able to build most of this XPath using wizard, but then had to edit
the XPath by inserting the current() reference.

Hope that helpls.

> Total newbie here, please excuse me. I've bound a drop down control in my
> form to one of the fields in an external LIST within my sharepoint site that
[quoted text clipped - 3 lines]
>
> If I were doing this in excel, I'd just do a VLOOKUP. Any ideas???

Reply to this Message

rchorner - 28 Jun 2005 07:29 GMT

Thanks, Bruce. I also found a very helpful link on this subject that walks
you through, step by step, with screenshots. My form is complete!

http://www.wssdemo.com/Pages/infopath_lookup_of_list_data.aspx?menu=Articles

> What worked for me was to add an Expression Box control. The DataSource had
> XPath:
[quoted text clipped - 13 lines]
> >
> > If I were doing this in excel, I'd just do a VLOOKUP. Any ideas???

Reply to this Message