InfoPath Dev

So - you could use any one of those fields as a data source for a dropdown (see attached screenshot) but you can't combine them. It sounds like you want to combine them (just the selected values) - but that can't be done out of the box. It would take code - and list forms don't support code. It may be possible to modify the XSL for the ...

 The fields are:Request TypeMailboxSAS_DatabaseSharepoint_site        

What field(s) have the values that you want to display the selection of in another dropdown? This may not be possible - if it is a single field that allows multiple selections, that can probably be done - but this is a list form and we can't use code, and we can't select non-repeating main data source fields as the source values for a ...

 Thank you for your reply! I can sum this up better now with some changes that I have made. What I need to do is get the selected values from 4 repeating tables (each different lists) and display them in a drop down list that will also be filtered by what has been selected. I hope I'm making sense.. here you are. Thank you for looking! :)

Any chance you can attach your template under the options tab in a reply? I usually understand questions better when I see the form.... If you are just looking to hide options in a dropdown if they have been previously selected (like in a dropdown in a repeating table) I'm attaching a sample - you can save the file locally & right click to ...

Sorry, I need more details here. It sounds like you just need rules on the fields bound to each of these controls. If it would be easier to explain with a sample form - feel free to attach a sample under the Options tab in a reply.

Awesome - it works perfectly!! Thank you so much Hilary

Use count of preceding-sibling to work around this: count(preceding-sibling::d:SharePointListItem_RW) mod 2 = 1 should work since your secondary data source is a list.....

Ah- that is because the total field being used for the sum function was not from the secondary data source (I think). Try this.

I am modifying the list form for a list of teams, stored in SharePoint 365 (cloud.) The form also has a secondary connection to another list, and uses a Form Load rule to query that list and pull items related to the team. I then display the query results in a repeating table. I wanted to implement alternate-row formatting (banding) to the ...