Unanswered

Update Excel from SQL

(0) Share

Report

Posted on by jjpreston29

I am trying to mirror an excel file from a SQL database. If the SQL entry does not exist in the excel file, it will 'add row into table'. If it does exist , then it will 'update a row'. But it just keeps adding rows.

see below. please advise

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @jjpreston29 ,

You could add a unique column in the excel table as a key column to check if the record exists.

Then you could use Filter to filter records in a table by the value of the key column in Sql table.

Use length() function to check if the record exists, if yes, update record; if no, create a new record.

If the type of key column is number, you could remove the single quote outside Dynamic content. And the unique column could not be empty.

Image reference:

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
jjpreston29 4 on at

Like (0)

Report

Thanks - your method works. I could see from the error that my filter was not working because my unique key in the excel was "Circuit-ID" - and it did not like the "-"

Was this reply helpful? Yes No