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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MT-21080103-0 4 on at

Like (0)

Report

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>

Was this reply helpful? Yes No