SharePoint Integration

Re: Accessing SharePoint columns via XPath

mjaneczk — Fri, 23 May 2008 13:49:35 GMT

Thanks for the direction. I figured it out using filtering. Essentially, I put a rule in my ToolName drop down which sets the ToolVersion text box. In the rule, I set a fields value based on an expression. In the expression I filtered based on teh value in the ToolName drop down.

Thanks!

Re: Accessing SharePoint columns via XPath

barmatt80 — Mon, 19 May 2008 20:29:58 GMT

I am not to sure. I know when i have queried a sharepoint list I got every single one back and had them populate repeating table. You might have to use a caml query to pull which one corresponds to the one listed in the list box. Or without code you might be able to use filtering within the info path form.

Accessing SharePoint columns via XPath

mjaneczk — Mon, 19 May 2008 18:45:13 GMT

I am trying to create an InfoPath form which reads from a SharePoint list. In particular, the SharePoint list has 2 columns (for now): ToolName, ToolVersion. The InfoPath form has a dropdown corresponding to the ToolName and a text box corresponding to the ToolVersion. I set up the data connection just fine. I can read the ToolName into thedrop down just fine. I set up the rule to populate the text box for Version. However, the text box only displays the version corresponding to the first item in the list. The XPath I have to do this rule is:

xdXDocument:GetDOM("ToolStore")/dfs:myFields/dfs:dataFields/dfs:ToolStore/@ToolVersion

I found in a previous article that I needed to add [../ID = current()/ID] to the end of my Xpath (from above). I tried that and it didn't work - I actually get nothing showing up in the text box.

Thanks in advance.

Mike