cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cholst Helper I
Helper I

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
Super User
Super User

Re: Getting ID when you have different identifier

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

View solution in original post

11 REPLIES 11
Super User
Super User

Re: Getting ID when you have different identifier

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
cholst Helper I
Helper I

Re: Getting ID when you have different identifier

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

Super User
Super User

Re: Getting ID when you have different identifier

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
cholst Helper I
Helper I

Re: Getting ID when you have different identifier

@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

Super User
Super User

Re: Getting ID when you have different identifier

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

View solution in original post

cholst Helper I
Helper I

Re: Getting ID when you have different identifier

@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"
}

 

Super User
Super User

Re: Getting ID when you have different identifier

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
Highlighted
cholst Helper I
Helper I

Re: Getting ID when you have different identifier

@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

cholst Helper I
Helper I

Re: Getting ID when you have different identifier

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

Super User
Super User

Re: Getting ID when you have different identifier

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
Super User
Super User

Re: Getting ID when you have different identifier

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

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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 (7,267)