Detect if Record Exist and create record if new.

[KMclendon]

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 Request

List 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 exist

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

[v-alzhan-msft]

Hi @KMclendon ,

You should create the flow as below:

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.

[KMclendon]

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.

[v-alzhan-msft]

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.