How do I get a user field from an entity reference?

Question

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.

1. I have a content type called Office (field_office), which contains the regional office name (imported from LDAP, but that probably doesn't matter.)
2. I have an entity reference user profile field called field_user_office that links to the Office content type.
3. 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?

Answer 1

You need to use the action: Fetch entity by property.

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