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

10 REPLIES 10
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.

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.

 

 

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,151)