cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cholst
Advocate III
Advocate III

Getting ID when you have different identifier

I'm using forms pro and running a trigger when the response is submitted. Since it's tied into my dynamics system i also want to pull back the record that was created in dynamics for more information. In the Microsoft forms trigger it doesn't store the GUID for the survey response in CRM but it does give me the source response identifier. Can i use that identifier to look up to CRM and bring back the GUID of the survey response? How can that be done?

1 ACCEPTED SOLUTION

Accepted Solutions

You can query the CRM using List Records (Dynamics or CDS connector) filter by response id to get the GUID back from CRM.

 

image.png

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

11 REPLIES 11
abm
Super User
Super User

Hi @cholst 

 

What is the source identifier format? Could you please show a screenshot of your run history?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @abm 

Here is a screenshot from the last failure. My trigger is from Microsoft Forms and when a new response is submitted. Then the action of Get response details and after that the action of get record using common data service. I'm trying to pull back the Forms Pro Survey Response record from CRM but tie it on the response ID instead of providing the GUID. Annotation 2020-03-18 091042.jpg

Hi @cholst 

 

How you planning the record from CRM? Could you show me the flow action step for this? Also you mentioned the error what's the error and details please.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@abm All i need right now it to get the record from CRM and since i don't have the GUID for that CRM record available to me it's failing. Forms pro is creating that record inside of crm so it will always have the same response id. Here is the error i talked about. 

Annotation 2020-03-18 092027.jpg

You can query the CRM using List Records (Dynamics or CDS connector) filter by response id to get the GUID back from CRM.

 

image.png

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@abm Thank you i think it's very close. I think my Odata query is slightly off. I set the Filter Query to the following and received the error below. 

msfp_sourceresponseidentifier eq @{triggerBody()?['resourceData']?['responseId']}

{
  "status": 400,
  "message": "A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.Int32' for operator kind 'Equal'.",
  "error": {
    "message": "A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.Int32' for operator kind 'Equal'."
  },
  "source": "devarinet.crm.dynamics.com",
  "errors": [],
  "debugInfo": "clientRequestId: ab37dd84-69e8-4ef9-9bf9-619ae4f2b5cb"
}

 

Think its expecting an integer. You have two options

 

Convert that to expression using int()

 

or declare a compose and map the value then map the output of the compose in your filter query.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@abm I've composed it to both int and string and the same error is thrown both time. The compose is grabbing the response id and the compose 2 is using either "@int(outputs('Compose'))" or "@string(outputs('Compose'))" as the input message to convert it. 

Any other ideas?

Annotation 2020-03-18 094955.jpg

@abm I got it to work. I was simply missing the ' '. Thanks for the help.

abm
Super User
Super User

Under the compose I can see you added that as a string. You need to add that as expression. 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @cholst 

 

Glad to hear that finally its all working.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,188)