Web Services

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Wed, 18 Oct 2017 17:46:25 GMT

Thank you Hilary for all your effort to help me with this. I think I have it working.

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Tue, 17 Oct 2017 23:13:47 GMT

I removed a rule on your button, then added one to clear fields so you could pick a letter then pick another one. :)

Also, I think I have the filters backwards here:

xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Dept = XPATH TO YOUR DEPT FIELD][count(current()/../preceding-sibling::my:group2) + 1]/d:ID

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Tue, 17 Oct 2017 20:45:39 GMT

Hi Hilary, I'm still having trouble. I took your sample from earlier in this post and modified it to demonstrate what I am trying to accomplish. In my sample, I am trying to filter States where their abbreviation begins with the letter selected from the drop-down.

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Mon, 16 Oct 2017 21:14:01 GMT

So, I'd guess you would want to set the ID field with something like this:

xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[count(current()/../preceding-sibling::my:group2) + 1][d:Dept = XPATH TO YOUR DEPT FIELD]/d:ID

With the bold part being the main data source field (or other field) bound to the dropdown list. Of course, it seems like you also could just not query your data on load, and instead query for just the data you need when the department dropdown changes? Set the list query field & execute the query?

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Mon, 16 Oct 2017 19:10:55 GMT

Can I see your form? You can email it to me if you don't want to post it here...

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Mon, 16 Oct 2017 19:06:04 GMT

Hilary, I am having trouble adding the filter as you suggest. I am not sure where to add it. I have 3 rules on a "Set" field that gets the ID in field1=xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[count(current()/../preceding-sibling::my:group2) + 1]/d:ID, the fullname in field2=xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title[../d:ID = current()/../my:field1], and the department in field3=xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Dept[../d:ID = current()/../my:field1]. The set=1 condition is on field2 and field3. Thanks

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Mon, 16 Oct 2017 14:39:20 GMT

I think instead of using a formatting rule to hide rows, you should only be populating rows where the department matches. So when you get your ID column, include a filter so that you are only getting the count of preceding-siblings that match on department. That way you aren't copying in data you don't need.

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Thu, 12 Oct 2017 17:55:34 GMT

Hilary, I got the SP list into my repeating table however my list is 1500 items. I am filtering based on the value of a department drop-down list. I currently have 100 groups inserted into the default values. I am then using a formatting rule on the repeating table to hide all rows where the department drop-down does not equal the department field in the repeating table. I am seeing if the repeating table row that meets the criteria doesn't fall in the first 100 rows of the SP list it doesn't display. Is there additional filtering needed?

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Wed, 11 Oct 2017 21:50:07 GMT

Got it. Thanks.

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Wed, 11 Oct 2017 19:21:02 GMT

The same basic approach for copying secondary data into the main data source will work. Insert the max number of rows you think you'll need under the default data setting. Add a rule to trigger setting the values - then set them. I usually set an ID field and set the other fields with that as a filter (as in the demo form).

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Wed, 11 Oct 2017 18:53:09 GMT

Hilary, I am now trying to do the same thing instead using a SP list. Rather than use a SP group to feed my repeating table, I am going to publish an excel spreadsheet to a SP list. I then need to pull the list items into my repeating table. Is there a different procedure to do that, our will the process you demonstrated in the DefaultDataWithRules2010.xsn work? Thanks.

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Fri, 22 Sep 2017 17:43:58 GMT

Hooray! Glad you have it working!

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Fri, 22 Sep 2017 17:40:14 GMT

Mission Accomplished. Thank you again and the willingness you always have to help us in the InfoPathdev community.

Re: Get Members of Distribution or SharePoint group

Hilary Stoupa — Fri, 22 Sep 2017 15:30:06 GMT

Here it is in 2010. :)

Re: Get Members of Distribution or SharePoint group

TOE_CHEESE — Fri, 22 Sep 2017 15:05:29 GMT

Thank you Hilary, you are always so helpful. Unfortunately your file won't open for me. I get an error saying it was created in a newer version of InfoPath and I'll need to install the latest version of InfoPath. Unfortunately, my enterprise admins aren't going to allow that. Can you duplicate the form in IP2010?