Power Platform Community Forum Thread Details

I am new to Power Automate. I am trying to create a flow that would update or create a contact when a Microsoft Form is completed. I have figured out how to use the connector to create a new contact from a Form response but I cannot figure out how to get the flow to update a contact if it is already in Salesforce, rather than create a new contact with the same name, possibly creating multiple duplicates of the same person. Can anyone please help me? Thanks!

Categories:

Building flows

Hi Heartlan12

You will need to search for contacts in Salesforce before inserting a new one to see if the contact already exists. And then do a condition branch where if the contact exists, do not create a new record and if the contact does not exist, then yes, create the new contact.

I have done this with a Get records from salesforce

and then with the loop for results I check to see if there is a contact ID returned matching my contact odata queury.

after that I use a variable that I am holding the ContactID in to go through a condition. if the ContactID = null then no record was returned and then I create the record. Otherwise if the contact ID is populated then I can perform other actions with that Contact in mind, such as a related record creation.