Add Sharepoint item if an identifier in column does not exist, Delete and replace if it does exist

[marcgiag]

I have successfully created a flow that

1. Watches for when a Dynamics 365 record is updated
2. If found and some conditions are met it will then create a record in a sharepoint list, using the Create Item function
3. One of the Dynamics fields is called "Opportunity" which is the only specific # that is not repeated in the CRM Table , this is then added to the Sharepoint list under "OPPID"

This works great...But every time the Dynamic record is updated a duplicate row is added to the SharePoint list

What I have been trying to do with no success is the following 

• Watch for a when a Dynamics 365 record is updated
• If found and some conditions are met, look for the new Dynamics record "Opportunity" field in the SharePoint "OPPID" column
  • If found
    • DELETE existing row, then
    • Add the row again, using the Create Item function of flow (I want the latest info)
  • If NOT Found 
    • Add the row, using the Create Item function of flow

Below is the flow I currently have that simply adds a row

[Eric6]

Hi marcgiag,

It looks like you typed "null" to represent an empty value, but this will be interpreted as the string "null". To represent an empty field try picking "null" from the expression tab of the dynamic content.

This should at least be a start.

Best regards,

Eric

[v-litu-msft · Accepted solution]

Hi @marcgiag,

You can use the Get items (SharePoint) action with the ODATA filter query ( OPPID eq 'Opportunity' ) to find the repeated record. Then use the length() function to judge whether find.

If found, update this item instead of deleting it, you can reduce one step.

If not found, create it.

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

[marcgiag · Accepted solution]

@v-litu-msft 

Took me a couple of trys (my own learning curve) but your instructions were great. Thank you!!!! I am providing my end result incase somone else needs it.

[marcgiag]

@Eric6  Thank you for the help with the null field... I made the correction and it is now in my end results post below