cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Support
Community Support

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.

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.

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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (24,615)