How do I get a user field from an entity reference? I'm working with the Twilio module to create a Rule that will send out an SMS message when a user creates a specific piece of content.  Here's how I've got things laid out at the moment.


I have a content type called Office (field_office), which contains the regional office name (imported from LDAP, but that probably doesn't matter.)
I have an entity reference user profile field called field_user_office that links to the Office content type.
I created a content type called Blast Message with an entity reference field called field_office_sms which also links to the Office content type.  When a user wants to create an SMS they create one of these nodes and select one or more offices to send to.


When I set up my rule I'm not seeing the fields exposed as I expected.  I tried adding two Entity has field conditions, Parameter: Entity: [node], Field: field_office_sms and Parameter: Entity: [node], Field: field_mobile_phone, the last of which is the actual mobile number saved in the users' accounts.

How do I navigate from the original content (Blast Message) through the Offices, then to the specific Users who are linked to that office, and ultimately retrieve their mobile phone numbers?
You need to use the action: Fetch entity by property.


Condition: Entity has field > node: field_office_sms
Fetch entity by property > User > Property: field_user_office > Value: node: field_office_sms:nid
Loop: List: [entity-fetched]
Action: Send SMS > list-item: field_mobile_phone