InfoPath Dev

 I haven't created any extra data connections yet (I thought this was specifically to deal with only one value in the drop down... which I can live with for now until the other bit works). But I can if you think it will help with the updating of the field?

2 screen shots, 1st is the drop down selection and a blank field. Second is the relevant row from the secondary data connection showing that user and associated area.
As an aside, would this data connection querying not show up in Fiddler? I was looking in fiddler to see what was being passed/returned but it shows no traffic when I make drop down selections

https://onedrive.live.com/redir?resid=c18b04d5bb544db4!5637&authkey=!AKTy8C-qmlJl5tU&v=3&ithint=photo%2cPNG

https://onedrive.live.com/redir?resid=c18b04d5bb544db4!5638&authkey=!AG7dQe5lzeSru6Y&v=3&ithint=photo%2cPNG 

I would expect the query to show up in Fiddler. I see in the sample template you uploaded to One Drive that you are executing the query. I would drag that data source onto the form so I could verify that the query field is being set and that the query is returning results.

Thanks, can you explain what you mean when you say drag the data source onto the form please?
When I click manage connections I see no way to drag anything onto the form. Am I misunderstanding?

 Sorry, I had fiddler set up to only record IE traffic for some reason.
The rule is generating traffic... not sure if this helps us get to the bottom of the rule not doing what we want though.
So from what I can see, when I make a drop down selection the list is getting queried and the name, title and area of my selection is getting returned... but then?
Nothing to do with the fact that the value is email but the display value is the name? Could it be as simple as us asking where email = name where we actually mean name = name?

Since you are only returning one row in the data source, you don't need a filter on the rule to set the value, right?

To be honest... I don't know :)

I haven't tried this before and everything I have done has been on advice/templates received here.
Outside of InfoPath I could do this a breeze 

As far as I know I only need to match where the name (display) in the drop down matches the name in the HRRep list.
From that lookup I need to return the "area" from the list and put this in the HS_Dept text box.

Sounds like it should be very easy, I can't see what is causing it to not populate 

What I am trying to explain is that it appeared to me that you were running a query that would return only one item - so you should be able to set the field to the value of that column in the secondary data source without using an XPath filter at all.

I am not sure there is a filter in place (see image at path below).
https://onedrive.live.com/redir?resid=c18b04d5bb544db4!5649&authkey=!AFBibdN3kjZP2mA&v=3&ithint=photo%2cPNG

Should I re-upload the template? 

You are setting the field to the query field value, not the data field. The query field is likely blank.

 You are a star!!! Thank you.

That is exactly what it was.