Unanswered

Avoid duplicate row add to Excel

(0) Share

Report

Posted on by ryan2k

176

Hi all. My flow has an action that adds a row to an Excel Spreadsheet. I'm trying to add a check so that if a column contains a matching value, it will skip adding the row. If the column does not contain a matching value, it will add the row. I think I'm part of the way there, but haven't gotten it to work as expected yet. Can someone help point out what I'm missing?

Screen Shot 2022-04-06 at 10.32.48 AM.png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

Re: Avoid duplicate row add to Excel

@ryan2k

Please check the below article it is doing the same but on sharepoint yet you can do the same using Excel by adding a filter query on List Rows to check if the row pre-existed, hope it gives you an idea!

https://onlinemgblog.wordpress.com/2021/05/29/building-flows-1-check-if-item-exist-and-update-if-exists/

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (1)

Report

Re: Avoid duplicate row add to Excel

Hi @ryan2k

You can even use these steps as well.

Get row from excel , so if not find it will throw error, so in config run after you can use handle exception if not able to find row, it will go for updated row.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No