Retrieving email address to send email to record owner

(1) Share

Report

Posted on by MT-21080103-0

I have what I feel should be a relatively simple question, but I cannot find the answer anywhere on the Internet.

I have built a flow that aims to send an email to a record owner (appointments) based on the scheduled date. I am using the Dataverse list rows action (and have been able to filter the rows), however when I go to send the email using the outlook connector, I can't seem to make it find the email address of the owner to place into the "to" field.

I have tried using "get a row by id" and retrieving the user details and then using the primary email however I still get errors.

Any help would be appreciated.

Categories:

Business Process Flows

All responses (2)

Answers (0)

MT-21080103-0 4 on at

Like (0)

Report

Retrieving email address to send email to record owner

Hi,

Thanks for the reply. Sorry for my slow response here. Here are the errors.

I'm guessing my Fetchxml query is not getting the users record ID?? Here is the fetch xml is that helps.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" no-lock="false"><entity name="appointment"><attribute name="statecode"/><attribute name="subject"/><attribute name="scheduledstart"/><attribute name="scheduledend"/><attribute name="regardingobjectid"/><attribute name="prioritycode"/><attribute name="activityid"/><attribute name="instancetypecode"/><attribute name="location"/><order attribute="scheduledstart" descending="false"/><attribute name="ownerid"/><filter type="and"><condition attribute="mom_reminderdate" operator="today"/></filter><link-entity name="systemuser" from="systemuserid" to="owninguser" link-type="outer" alias="a_eb693375a8fb4c43a2f3e63f894d00e1" visible="false"><attribute name="internalemailaddress"/></link-entity></entity></fetch>
Suggested answer

Michael E. Gernaey 43,417 Super User 2025 Season 1 on at

Like (0)

Report

Retrieving email address to send email to record owner

Hi,

Please share the error you are getting, as well as a run (with the error), and all the inputs and outputs of each Action

We definitely need to see the input value to the Get Row Id as well as the Output from it so we can verify why its blank.

Also, did you Make sure, that the Dynamic Property Primary Email is from the Get Row from ID and NOT from your initial Get Items??

I see people accidentally grab the wrong one all the time

Thanks

Community site session details

Retrieving email address to send email to record owner

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Retrieving email address to send email to record owner

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates