cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JonesEA_2019
Level: Powered On

Send Email to "Call From" on Phone Entity

Hello,

 

How do I pull the email address for the contact entered as the "Call From" on the Phone Call entity?

"Call From" isn't accessible from the Dynamics 365 trigger or the CDS trigger. 

 

Thanks!

Beth

11 REPLIES 11
Community Support Team
Community Support Team

Re: Send Email to "Call From" on Phone Entity

Hi @JonesEA_2019,

 

You can use the compose action to test the triggerBody()?['CallFrom'] whether will work.Annotation 2019-10-15 145637.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JonesEA_2019
Level: Powered On

Re: Send Email to "Call From" on Phone Entity

Thanks for the suggestion, v-litu-msft! That got me moving in the right direction.

 

Any suggestion on how to use that to find the email address in contacts?

The Find Call From action succeeds but the next action, Get record 2, fails.

Screenshot:

Call From Contact.JPG

 

Thanks!

JonesEA_2019
Level: Powered On

Re: Send Email to "Call From" on Phone Entity

I kept playing around and finally something to just worked on the Get Record 2 action.

I tried using contactid again:  body('Find_Call_From')?['value'][0]['contactid']

This time the function appeared "correctly" instead of written out completely
Get Record 2 correct.JPG
 
BUT, the send email action failed.  No email address found?
{"ErrorMessage":"System.Exception: SendEmailsForFlowRequestHandler::Transform:: distribution list count can't be empty\r\n at Microsoft.Forms.Pro.ApiFacade.Requests.FlowSendMessageRequest.Transform(TelemetryLogger telemetryLogger, HttpRequestContext requestContext)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<ParseRequestData>d__11.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<DoValidate>d__10.MoveNext()"}
 
 
Community Support Team
Community Support Team

Re: Send Email to "Call From" on Phone Entity

Hi @JonesEA_2019,

 

Could you share an example of the trigger's output?

We should make sure the column name in the system is Call From or CallFrom, or the expression will not work.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

JonesEA_2019
Level: Powered On

Re: Send Email to "Call From" on Phone Entity

So, below is the trigger output for my test. The Call From field isn't part of the results. Its name is 'from' actually and it's a party list field. It is in the Dynamics table but is not available from the list in Flow's Dynamic Content.

 

I changed the compose field to use 'from' to see what would happen and got the same error message (System.Exception: SendEmailsForFlowRequestHandler. . .). The email address isn't getting pulled from Contacts. 

 

This is the send survey action:

Send Survey 101619.JPG

OUTPUTS (trigger)

1st Call/Email Resolution? 563310000
1st Call/Email Resolution? Label Yes
Activity Status 1
Activity Status Label Completed
Actual End 2019-10-16
Created By 02b62fac-ee29-e711-8110-c4346bad9668
Created By Type systemusers
Created On 2019-10-16T13:51:17Z
Direction false
Duration 30
Is Billed false
Is Workflow Created false
Left Voice Mail false
Modified By 02b62fac-ee29-e711-8110-c4346bad9668
Modified By Type systemusers
Modified On 2019-10-16T13:51:17Z
Owner 02b62fac-ee29-e711-8110-c4346bad9668
Owner Type systemusers
Phone Call d0d3ef05-1cf0-e911-a98d-000d3a1993e0
Phone Number ###-###-2311
Priority 1
Priority Label Normal
Process 00000000-0000-0000-0000-000000000000
Regarding c460dabf-79ef-e911-a984-000d3a199997
Regarding Type kipu_accountteammemberses
Status Reason 4
Status Reason Label Received
Subject Test Survey Send
Time Zone Rule Version Number 0
Topic - Incoming 563310052

JonesEA_2019
Level: Powered On

Re: Send Email to "Call From" on Phone Entity

I added a field to the phone call entity and used a workflow to populate it with the call from value.  That field is returned in the trigger output and the compose field finds it (action doesn't fail). The get record step is still returning the entire contact entity and  the send survey action still fails. 

Community Support Team
Community Support Team

Re: Send Email to "Call From" on Phone Entity

Hi @JonesEA_2019,

 

Is Phone call the "Call from" you want?Annotation 2019-10-17 174529.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JonesEA_2019
Level: Powered On

Re: Send Email to "Call From" on Phone Entity

Yes, I want to get the email of the contact shown as the Call From on the phone call record.

Community Support Team
Community Support Team

Re: Send Email to "Call From" on Phone Entity

Hi @JonesEA_2019,

 

You can provide me the original format of the trigger output, I notice that the column name of call from is not CallForm, it seems like

1st Call/Email Resolution? 563310000
1st Call/Email Resolution? Label Yes

So, I guess you want to get the 563310000. If you give the output of it, it will be easier.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
JonesEA_2019
Level: Powered On

Re: Send Email to "Call From" on Phone Entity

This is taking up too much of our time. I'm going to table it. Maybe in the future there will be a way to pull the email address for the contact in a phone call record's "call from" field.   

 

Thanks for your time, v-litu-msft.

 

 

 

 

FabiolaGRT
Level: Power Up

Re: Send Email to "Call From" on Phone Entity

Hi @JonesEA_2019 .

I hope your problem has been solved. I had the same issue.

In my case, I want to send a survey when statuscode equal to "Complete", the only thing I added was another conditioner specifying the type of activity adding this it works and send the survey. I hope it works for you.

Flow.png

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,353)