Qdabra qRules

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

Hilary Stoupa — Wed, 10 Aug 2011 21:53:51 GMT

If you put the repeating Approvals group in its own non repeating group, then modify your Insert command to use that as the parent, you won't have to worry about this. I've emailed your form back to you with this change in place.

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 21:35:09 GMT

I sent you the form but then I saw this. I didn't know about moving them up or down in the node. Moving it to the top made it work. Not sure I understand exactly what happens there as they are separate groups, but since it is working I'm going to keep moving forward.

Thank you so much!

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

Hilary Stoupa — Wed, 10 Aug 2011 21:04:43 GMT

So the error is probably going to be occurring on the rule that inserts the nodes into the main data source? Can you just move your new group up in the main data source? I could offer more concrete help if I could see what was up, but working blind means I have to guess. :-}

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 20:06:46 GMT

Just a little more info; if I just add a new group under myFields without putting anything on the form then it stops working.

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 20:03:12 GMT

Sorry; it works with just the table but as soon as I add any controls like a drop-down it then returns zero rows.

Thanks

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 20:01:13 GMT

OK; sorry to keep being a pain, but everything works great now. However, as soon as I add any other controls anywhere on the form then the list won't load. No error or anything, it just has zero rows. All I did was insert a separate 2 column table which did not even have any control inside it...

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 19:02:18 GMT

annnnd... I believe that worked! You m'lady are a genius!

Thank you so much!

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

Hilary Stoupa — Wed, 10 Aug 2011 18:53:14 GMT

Try using relative XPath in places you currently have absolute:

Year = xdXDocument:GetDOM("Approvals")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Year[../d:ID = current()/my:myID]

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 18:38:08 GMT

Oh; also the last rule is the decrement count:

xdXDocument:GetDOM("ViewOptions")/Util/fields/Count - 1

I assume that works fine since the table populates with the correct amount of records.

Thanks

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 18:35:22 GMT

The first rule is Set ID and here is the xpath:

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

then I have a rule to set each field:

Year = xdXDocument:GetDOM("Approvals")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Year[xdXDocument:GetDOM("Approvals")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID = current()/my:myID]

Quarter = xdXDocument:GetDOM("Approvals")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quarter[xdXDocument:GetDOM("Approvals")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID = current()/my:myID]

etc

I did figure out the blank column issue by looking at the xml like you suggested. That is helpful even though I don't fully get it yet. The only remaining issue is the fact that every row is showing the list item from SP that has an ID = 1

BTW, I changed all of the Main fields to be prepended by "my" so I can easily see the difference.

Thanks!

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

Hilary Stoupa — Wed, 10 Aug 2011 18:24:27 GMT

Give me the sample XPath you are using to set one of the values in your form - perhaps I can see from there.

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 17:47:16 GMT

Unfortunately I think that would go against my company's policy though I will try to ask around if I can do that. The actual data is completely fake but since it is on our work server I have no idea if It's permissable. I realize it may be impossible to troubleshoot further without it but you have been a huge help already!

Thanks!

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

Hilary Stoupa — Wed, 10 Aug 2011 17:32:59 GMT

Any chance you can attach your template to a reply? Under the Options tab.... then I can maybe see what's up?

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 17:17:13 GMT

Just for a little more info:

- I have 5 items in my SP list

- It puts 5 rows in my IP table with IDs of 5-1

- It is loading all IP rows with the data from the SP row with an ID of 1

- One of the columns is staying blank for all rows even though there is data in the list; this formula is the same as the others too

Apparently even though the counter is decrementing correctly it is somehow not tying each row to the ID number at the time the row is populated. I have no idea why the one field is blank.

Not sure if you can help with that but thanks again!

Re: Copy SharePoint List Values to InfoPath Repeating Section Fields - Formula Error

King5555 — Wed, 10 Aug 2011 17:02:41 GMT

FYI, I just tried using the XML count and I think it does what it's supposed to. I'm getting very close but I seem to have one more issue. When I preview the form it correctly inserts the same number of items that I have in my SP list but the data in the other columns all comes from the first ID in the list. I will try to troubleshoot that myself but if you have any ideas I always appreciate them.

Thanks!