The activities have a field named Regarding which is of type Multi-table lookups. This field supports several types like account, contact, lead (…). This post will discuss how to get the type of lookup used or in other words which table is used with Power Automate Cloud Flows.

For the demo, I created a simple flow that is triggered when a task is created. Then I store the type of the regarding field with the Compose action.

To get the type of the regarding field. The trigger output offers the regarding (type) option which implements the expression “triggerOutputs()?[‘body/_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname’]“

At the time of writing this post, the trigger output does not contain this property… The standard expression Regarding (Type) return an empty value. This seems to be a bug (…)

---

To get the type of the field regarding. We must use the following expression:

triggerOutputs()?[‘body/_regardingobjectid_type’]