{"id":479,"date":"2016-02-25T10:45:30","date_gmt":"2016-02-25T15:45:30","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=479"},"modified":"2016-02-25T10:45:30","modified_gmt":"2016-02-25T15:45:30","slug":"filtering-infopath-drop-down-list-on-previous-future-selections","status":"publish","type":"post","link":"https:\/\/www.markwheeler.com\/?p=479","title":{"rendered":"Filtering InfoPath drop-down list on previous, future selections"},"content":{"rendered":"<p>Another requirement for my <a href=\"http:\/\/markwheeler.com\/wordpress\/?p=459\">teleconference reservation form<\/a> was to only allow one unique user to be assigned to a number.<\/p>\n<p>I had to figure a way to filter or exclude previously selected users from other drop-down box selections.<\/p>\n<p>My user drop-down is populated via the Attendees people picker field from the Main datasource.<\/p>\n<p><a href=\"http:\/\/54.159.73.21\/wp-content\/uploads\/2016\/02\/DropDownRules4.png\" rel=\"attachment wp-att-480 noopener\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2016\/02\/DropDownRules4-250x300.png\" alt=\"DropDownRules4\" width=\"250\" height=\"300\" class=\"alignnone size-medium wp-image-480\" srcset=\"https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules4-250x300.png 250w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules4.png 442w\" sizes=\"auto, (max-width: 250px) 100vw, 250px\" \/><\/a><\/p>\n<p>I then created a filter on the Person group datafields to limit the drop-down options displayed.<br \/>\nThe actual expression is:<\/p>\n<pre>\nnot(pc:DisplayName = xdXDocument:getDom(\"ConferenceMaster\")\/dfs:myFields\/dfs:dataFields\/d:SharePointListItem_RW\/d:User)\n<\/pre>\n<p><a href=\"http:\/\/54.159.73.21\/wp-content\/uploads\/2016\/02\/DropDownRules.png\" rel=\"attachment wp-att-481 noopener\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2016\/02\/DropDownRules-300x155.png\" alt=\"DropDownRules\" width=\"300\" height=\"155\" class=\"alignnone size-medium wp-image-481\" srcset=\"https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules-300x155.png 300w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules-1024x529.png 1024w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules-768x396.png 768w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules.png 1509w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>The resulting form looks like this; Only when Assign is clicked do the following drop-down boxes filter.<\/p>\n<p><a href=\"http:\/\/54.159.73.21\/wp-content\/uploads\/2016\/02\/DropDownRules2.png\" rel=\"attachment wp-att-482 noopener\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2016\/02\/DropDownRules2-300x170.png\" alt=\"DropDownRules2\" width=\"300\" height=\"170\" class=\"alignnone size-medium wp-image-482\" srcset=\"https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules2-300x170.png 300w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules2.png 674w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/54.159.73.21\/wp-content\/uploads\/2016\/02\/DropDownRules3.png\" rel=\"attachment wp-att-483 noopener\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2016\/02\/DropDownRules3-300x169.png\" alt=\"DropDownRules3\" width=\"300\" height=\"169\" class=\"alignnone size-medium wp-image-483\" srcset=\"https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules3-300x169.png 300w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/DropDownRules3.png 665w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>For reference, my Assign button rules are depicted here:<\/p>\n<p><a href=\"http:\/\/54.159.73.21\/wp-content\/uploads\/2016\/02\/AssignRules.png\" rel=\"attachment wp-att-484 noopener\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2016\/02\/AssignRules-245x300.png\" alt=\"AssignRules\" width=\"245\" height=\"300\" class=\"alignnone size-medium wp-image-484\" srcset=\"https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/AssignRules-245x300.png 245w, https:\/\/www.markwheeler.com\/wp-content\/uploads\/2016\/02\/AssignRules.png 331w\" sizes=\"auto, (max-width: 245px) 100vw, 245px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Another requirement for my teleconference reservation form was to only allow one unique user to be assigned to a number. I had to figure a way to filter or exclude previously selected users from other drop-down box selections. My user drop-down is populated via the Attendees people picker field from [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[10,11],"tags":[58,99],"class_list":["post-479","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-software","tag-infopath","tag-sharepoint-2010"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=479"}],"version-history":[{"count":0,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/479\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}