Unanswered

Merge operation(If exists update else insert) in flow

(0) Share

Report

Posted on by Community Power Pla...

I am trying to create the below flow which calls an api on daily basis and inserts data into sql server table row by row in a loop.

I want to execute a merge operation here that is before final inserting into table I want to check if this data already exists in table or not. How do I achieve this in flow. Pls help.

. I want to

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Before you insert check the record exists using Get Row or Get Rows using Filtery query to match the identifier. Add an IF condition to check whether the record exists or not.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

I have done a work around and added execute procedure step in flow executing update from a stored procedure

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have done a work around and added execute procedure step in flow and executing merge operation from a stored procedure

Was this reply helpful? Yes No