InfoPath Dev

Hello,

I have a list named: Roles with 2 columns: email and department.

I have 5 items in this list: 2 of them are from Marketing. and the other 3 are from HR.

I have a text in my InfoPath form that every form load sets this textbox with the email of the current user.

I want to iterate the Roles list and check if the current user is from Marketing then hide this control.

The problem is that when I do it, it only brings back the LAST row from the iteration.

Does someone know anything about it? or tried it? (Although when I think of that, InfoPath doesn't know when to stop iterating)

There are a couple of ways you can go about this.  You can use a SP list connection then use query fields to only return the list item where the email matches the person who opened the form.  Then you can just use a rule to check what department that person belongs to.

Or you can retrieve all the data and use rules again to filter the entries based on email then look up the department similar to the previous suggestion.  Hopefully that gets you down the right path.  Let me know if you need additional help on how to implement.