Qdabra qRules

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Wed, 28 Sep 2011 10:47:55 GMT

Stil got the same issue.....

However I now seemed to have resolved it, I first of all typed in :

xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID

I then verified the formula whic then changed to ID

The clicked Edit XPath and added in :

[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]

Now the complete formula looks like this:

xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/d:ID

And finally the formula has no errors....... Thanks for all your assistance on this one finally solved....

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

Jimmy — Wed, 28 Sep 2011 08:30:15 GMT

You did not remove all of the extra bits. The xdXDocument:GetDOM("ArtefactsListData") towards the end is the part that's causing the errors. This is what you need:

xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/d:ID

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Wed, 28 Sep 2011 07:43:53 GMT

You are correct, I have now added the "s" (School Boy Error) but I now get this:

Formula=

xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID

Error=

Node-test expected.
xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/-->xdXDocument:GetDOM<--("ArtefactsListData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID

Or removing the extra bits as previously advised:

Formula=

xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/xdXDocument:GetDOM("ArtefactsListData")/d:ID

Error=

Is there any way of entering this formula by clicking various commands in the rules as opposed to manually typing it in???

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

Jimmy — Tue, 27 Sep 2011 12:57:09 GMT

Are you sure you're not missing an s in "ArtefactListData" or something like that?

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Tue, 27 Sep 2011 12:41:56 GMT

If I remove it the formula looks like this:

xdXDocument:GetDOM("ArtefactListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/d:ID

I now get the error message:

Function 'GetDOM' did not return a value, or it returned a value that cannot be converted to an XSL data type.

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

Jimmy — Tue, 27 Sep 2011 12:34:27 GMT

Looks like you need to remove the part between ] and /d:ID:

xdXDocument:GetDOM("ArtefactListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(GetDOM("ViewOptions")/Util/fields/Count)]/d:ID

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Tue, 27 Sep 2011 10:59:30 GMT

After selecting Edit XPath the following is displayed (This is with regards to my original form):

GetDOM("ArtefactListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(GetDOM("ViewOptions")/Util/fields/Count)]/xdXDocument:GetDOM("ArtefactsListData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

Jimmy — Tue, 27 Sep 2011 10:13:54 GMT

Looks like there's a problem with the way you set up the formula. Could you click the Show XPath document and see if there isn't a bunch of extra stuff before d:ID?

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Tue, 27 Sep 2011 08:55:16 GMT

As a further note I have gone back to the documented instructions and tried to create exactly the same solution that is detailed, same fields etc and I am still getting the same errors:

Formula=

xdXDocument:GetDOM("Contract Customer")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/ID

Error=

Node-test expected.
xdXDocument:GetDOM("Contract Customer")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/-->xdXDocument:GetDOM<--("Contract Customers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID

Not sure what I am doing wrong...

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Tue, 27 Sep 2011 07:25:16 GMT

I have tried the above and I now get this message:

Function 'GetDOM' did not return a value, or it returned a value that cannot be converted to an XSL data type.

If I then change ID to be the ID field of the secondary data connection I receive the original error again....

I have attached a copy of the problamatic form if that helps?

Thanks in Advance

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields

Hilary Stoupa — Mon, 26 Sep 2011 18:04:15 GMT

Try:

xdXDocument:GetDOM("ArtefactListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/ID

Copy SharePoint List Values to InfoPath Repeating Section Fields

abrag1977 — Mon, 26 Sep 2011 14:56:21 GMT

I am experiencing a problem when following the QDabra published guide to perform the above task.
I am currently on page 14 "Add Rules to Repeating Section", however I have hit a brick wall trying to add the first rule: Set ID..

The formula I have put into the value field is:

GetDOM("ArtefactListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(GetDOM("ViewOptions")/Util/fields/Count)]/ID

The verify error I am getting is:

Node-test expected.
GetDOM("ArtefactListData")/dfs:myFields/dfs:dataFields/dfs:SharePointListItem_RW[number(GetDOM("ViewOptions")/Util/fields/Count)]/-->xdXDocument:GetDOM<--("ArtefactsListData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID

I have found a similar post on this forum regarding this and have read its content but I still cannot resolve this issue.

Any help on this would be much appreciated

Thanks in Advance

Geoff