sharepoint server – Infopath2013 Form – Using a Drop down to tell which part of a repeating section to show


I have a large form that uses repeating sections to show data so a user can make a better decision when filling out the form. The form is bound to a sharepoint list which is a work queue for assigning system access transactions. In the top portion of the form, the requestor uses a drop down (non repeating) to select which office the user will need access in. In the bottom portion of the form, the requestor has to select an approver & a processor. Next to these field selections is a repeating section that shows a list of all offices, their listed approver and their listed processor. I would like to find a way to make it so that the only office that shows in this repeating section is the one that is chosen in the first part of the form. This way, instead of having to scroll through all offices in the repeating section, only just the one section for that office shows. I have tried formatting rules where after the item is selected in the drop down it highlights that office below but that did not work. I’ve also tried to hide offices that do not match the selected office and that did not work. Help please 🙂