Filter a Repeating Drop-Down List on Previous and Future Selections - InfoPath Dev
in

InfoPath Dev

Filter a Repeating Drop-Down List on Previous and Future Selections

Last post 02-25-2016 07:25 AM by hotwheels. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-24-2016 02:44 PM

    Filter a Repeating Drop-Down List on Previous and Future Selections

    I have a drop-down in a repeating field that I need to limit to unique choices. The drop-down is populated by a people picker on the same form. http://www.markwheeler.com/img/TRequest.png The repeating section is only available to "admins" where they can assign teleconference numbers to a scheduled request. These numbers also need to have a unique user assigned to them. How can I remove previously selected users from showing up in repeating drop-downs once selected? The people picker is in the Main dataconnection at Attendees > Person > (I am using) DisplayName in the drop-down. The User field in the repeating section is in a Secondary Data Connection (Conference Master). I submit those lines of data via an XML New method to UpdateListItems. I just can't quite figure out the xdXDocument:get-Dom() or preceding-sibling solutions found elsewhere on these forums. When an admin clicks the Assign button, I am writing that repeating data to a second SharePoint list.
  • 02-25-2016 07:25 AM In reply to

    Re: Filter a Repeating Drop-Down List on Previous and Future Selections

    I actually got this to work for me. The following expression had to be applied to the pc:Person datafield. not(pc:DisplayName = xdXDocument:getDom("ConferenceMaster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:User) The following drop-down box does not actually get filtered until the Assign button is clicked; as shown in the screenshot in my original post.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.