cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RSTSi
Frequent Visitor

Using MS Forms Pro to Update Contact Details in D365

Hi everyone.

Beginner Power Automate user here.

I've been tasked with creating a flow that takes manually-entered contact details from a MS Form Pro survey and update details within an associated Contact entity within our Dynamics 365 environment.

Here's the fun part: I can't find any way to link a received form with the associated Contact entity.

 

I've tried "List Records" and filtering them by the email address entered in the survey, "Get Record" and trying to use the email address from the survey to link it to a Contact with the same address, "List Records" then "Get Record" using a custom-made Contact ID field, but I keep getting error 400.

 

Figure 1.png

Figure 2.png

 Figure 3.png

 

Figure 4.pngFigure 5.png


I believe that maybe, if I can get the GUID for each Contact onto the form somehow, I will be able to solve the connection issue as the errors I'm getting seem to be looking for it. This I'm also having trouble with, but I feel that that's a discussion for another community.

 

Figure 6.png

 

 

Am I close? Or am I going in the completely wrong direction? Is it even possible to do this with MS Forms Pro yet?

Any and all help/advice/insight would be greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
edgonzales
Super User II
Super User II

@RSTSi 

Hi there.  So, I think the "Item Identifier" in the CDS "Get Record" step is actually the GUID vs. the contact email.  I wonder if you could do a "List Records" step with an OData filter on the email eq 'form response', and then take the first result of that to avoid the subsequent Apply to Each loop.

 

That should get you the actual GUID for the Update Record step.

 

Keep us posted.

-Ed-

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

4 REPLIES 4
edgonzales
Super User II
Super User II

@RSTSi 

Hi there.  So, I think the "Item Identifier" in the CDS "Get Record" step is actually the GUID vs. the contact email.  I wonder if you could do a "List Records" step with an OData filter on the email eq 'form response', and then take the first result of that to avoid the subsequent Apply to Each loop.

 

That should get you the actual GUID for the Update Record step.

 

Keep us posted.

-Ed-

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

RSTSi
Frequent Visitor

@edgonzales 

 

You're an absolute legend mate! Worked like a charm!

 

Thanks for your help, I super appreciate it.

RSTSi
Frequent Visitor

For those interested in the flow, here's the flow from top to bottom:

 

Successful Flow.png

 

For clarification, the Response ID in the Get Response Details step is: int(triggerBody()?['msfp_sourceresponseidentifier'])

 

@RSTSi - one thing to keep in mind also, is having a step to make sure the record exists, and if it doesn't create one. This shows a flow very similar to the one you created, but also has an additional step to confirm it's in your CDS environment. From the part onwards where it shows the List Leads step. This way you can always link an anonymous survey response to an existing record OR create a new one if there isn't one. Helps cut down on duplicates too! 

https://meganvwalker.com/duplicate-checking-for-forms-pro-survey-responses/

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (47,383)