https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/79548.aspxFri, 15 Jun 2012 16:29:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79548Anson Hidajat0https://www.infopathdev.com:443/forums/thread/79548.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=79548<p>There are a couple of ways you can go about this.&nbsp; 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.&nbsp; Then you can just use a rule to check what department that person belongs to.</p><p>Or you can retrieve all the data and use&nbsp;rules again to filter the entries based on email then look up the department similar to the previous suggestion.&nbsp; Hopefully that gets you&nbsp;down the right path.&nbsp; Let me know if you need additional help on how to implement.</p>https://www.infopathdev.com:443/forums/thread/79394.aspxMon, 11 Jun 2012 15:50:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79394wintert0https://www.infopathdev.com:443/forums/thread/79394.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=79394<p>Hello,</p> <p>I have a list named: Roles with 2 columns: email and department.</p> <p>I have 5 items in this list: 2 of them are from Marketing. and the other 3 are from HR.</p> <p>I have a text in my InfoPath form that every form load sets this textbox with the email of the current user.</p> <p>I want to iterate the Roles list and check if the current user is from Marketing then hide this control.</p> <p>The problem is that when I do it, it only brings back the LAST row from the iteration.</p> <p>Does someone know anything about it? or tried it? (Although when I think of that, InfoPath doesn&#39;t know when to stop iterating)</p>