Unanswered

Dataverse Email Table -- Using to Send Emails

(0) Share

Report

Posted on by EscapedAnteater

Hey Folks, so I am looking to send an email in D365CRM via a flow. I've gotten the thing to work all the way up to a final 'send email'.

Here is my "Send EMail" block and the error I'm getting is

URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL.

My question is this - I have a feeling I'm getting lose in "parties" .. do both parties need to be a D365 contact? Can either of them just be an email address?

Any tips on how I can get that block to work?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

JonDoesFlow 1,304 on at

Like (0)

Report

Timely post. I was doing this today. The contact that you want to send the email from needs to be in the contact table as you need to use the activity parties fields and then reference the contacts(Guid) in the field. Remove the forward slash in your screenshot.

For the sender, if this is a system email address you’ll be able to find it in the Users table and that is referred to by systemusers(GUID). I am not sure if you can use a hardcoded email address in the From field as per your screenshot.

I followed this blog to help me today

https://www.d365geek.co.uk/single-post/create-and-send-emails-with-attachments-in-d365-dataverse-with-power-automate

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
EscapedAnteater 23 on at

Like (0)

Report

Thanks! Flipped the "sender" to this

And that record does indeed have an email. Still get the same error. I'm going to try to define the sender in the parties section up top and see what happens.

Was this reply helpful? Yes No
EscapedAnteater 23 on at

Like (0)

Report

**bleep**, same problem. I'm going to try contact(GUID) instead of contacts(GUID) but here's what I got

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

Check your dataverse contact table, do those GUIDs exist ?

also check the Users table.

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

Contacts is correct as it’s the plural of the table name.

Was this reply helpful? Yes No
EscapedAnteater 23 on at

Like (0)

Report

Here are the values in Contacts, they exist and have email addresses.
I'm not sure what I'm looking for in the users table or how it relates to this.
(Note, I've taken off anything in the "sender" part and instead and just using a "sending" party up top

(Don't be thrown off by the SQL, I'm using SQL2CDS in XRMToolbox as it seems MUCH faster than browsing through tables and using UIs)

Was this reply helpful? Yes No
EscapedAnteater 23 on at

Like (0)

Report

UPDATE! I took off the reguarding(cases) bit and it worked. I've tried a few things now on that and they all haven't worked.

What DID work was
incidents(CASE)

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

Yes this is where the Case table has Case for the name but the logical name is incident.

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

my blog post around entity set names might help you

https://www.jondoesflow.com/post/update-a-dataverse-record-and-link-to-a-related-table-by-using-the-plural-table-name

Was this reply helpful? Yes No