Newbie Questions

Re: Filter & Retrieve Data from 2 Sharepoint Lists

shaun.nieves — Wed, 24 Oct 2007 17:26:06 GMT

Sorry it took so long to reply. The method I use (which I found somewhere here but can't remember) is not that elegant but works for my purposes and may work for yours. Create an xml document like this

Import it as a secondary file. Create a rule for your dropdown that sets RowPosition - count(../preceding-sibling::my:Your repeating node) + 1

Then when setting up your conditional functionality, use the rowPosition in your xpath - xdXDocument:GetDOM("ProfileCapture")/dfs:myFields/dfs:dataFields/dfs:ProfileData/@WNAME[../@PROFILENUM = xdXDocument:get-DOM()/my:myFields/my:Waste_Line_Items[number(xdXDocument:GetDOM("Support")/Support/RowPosition)]/my:PROFILENUM]

Hope this helps. Cheers!

Re: Filter & Retrieve Data from 2 Sharepoint Lists

hodgy — Wed, 17 Oct 2007 06:47:10 GMT

Indeed, the fields will be filled based on a drop down selection. I am currently trying to implement based on some conditional formatting but it isnt giving me what i want.

I have repeating section A - it contains FirstName, LastName, Organisation
I have repeating section B - it contains Organisation, Address1, Address2, Postal_Code ...etc

I attempted to "nest" repeating section B inside repeating section A and said "hide this control" when Organisation from section B NOT EQUAL TO Organisation from section A. HOWEVER, this comparison always takes the Organisation value of the very first record in section A. I have tried to implement using current() but it's not quite giving me what i need.

Any suggestions would be greatfully received as this is now an urgent issue.

Re: Filter & Retrieve Data from 2 Sharepoint Lists

shaun.nieves — Tue, 16 Oct 2007 19:33:25 GMT

One question, how do you plan on implementing your form? You can easily do this with managed code however if you want to automatically fill the fields based on a dropdown selection then it would be easier to use rules.

Filter & Retrieve Data from 2 Sharepoint Lists

hodgy — Mon, 15 Oct 2007 09:19:03 GMT

Hi, I have the following scenario:

I am trying to populate a simple repeating section in infopath with values from 2 sharepoint lists.

- Sharepoint List A contains info FirstName, LastName, Company.
- Sharepoint List B Company, AddressLine1, AddressLine2, PostalCode

What I need to achieve is that when the form is loaded, the FirstName, LastName, Company, AddressLine1, AddressLine2, PostalCode are ALL populated. I can get data from Sharepoint List A very easily, but i now need it to retrieve the Company address from List B based on the value of Company in List A. I'm sure this has been discussed, achieved before, any links to similar solutions, explanations, ideas would be greatfully received.

Thanks