I've tried using Power Automate to send an email when a new activity is created in Dynamics 365 Finance & Operations. The email should be sent to the user that is assigned as responsible for the activity.
I've created a flow that runs when a new business event is created (an alert in Dynamics).
With the activity number I'm able to use “Get a record” to get the activity from the Activities entity.
Problem: The output does not show “responsible”, hench I'm unable to get the users email address.
How can I get the email address of the user in the field “responsible” with Power Automate?
Or can it be achieve without Power Automate?