cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Detect if Record Exist and create record if new.

I am building a flow that is an HTTP Request. This request polls a number of records that all have unique serial numbers (ID). What I am trying to do is put a condition in place that essentially says---> if the HTTP "Body" contains an "ID" that =Equals= a Serial Number existing Customer Asset record in Field Service --->  If "YES"---> Terminate ---> if "NO"---> create a record ( A Customer Asset) in Field Service. I am having some trouble building this out. 

 

GET RequestGET Request

 

List Customer Asset Records and Filter to show Where the Serial Number Contains DataList Customer Asset Records and Filter to show Where the Serial Number Contains Data

If  the "ID" from the HTTP Body Equals the Serial Number that existIf the "ID" from the HTTP Body Equals the Serial Number that exist

IF NO they don't Match- Create the following Records.....If YES Do nothingIF NO they don't Match- Create the following Records.....If YES Do nothing

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Detect if Record Exist and create record if new.

Hi @KMclendon ,

 

You should create the flow as below:

1.png

length(body('Filter_array'))

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
New Member

Re: Detect if Record Exist and create record if new.

Thanks for the suggestion, however this is not working as intended. The Goal is to run a Flow that will 1). Pull values from a Server via HTTP request.

2.) Pull a List of Records that already exist in Dynamics.

3). Validate if what Is being polled against what already exist in CE. If a record does not exist, then create a New Record. If the record does exist then do nothing.  

 

Unique serial numbers are used to identify the existence or non existence of these records.

Highlighted
Community Support
Community Support

Re: Detect if Record Exist and create record if new.

Hi @KMclendon ,

 

Have you take a try with the provided solution, it would work for your requirement.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,913)