Getting duplicated values, even with lenght formula

[luiscalleja11]

Hi!

I kind of need some help in a flow,

I´m creating a SharePoint list using an online excel file, but every time test the flow I get duplicated items, I´m using the

length is equal to 0 formula, but doesn´t work to avoid the duplicated items.

Any suggestion would be helpful!

TY!

 

[Expiscornovus]

Hi @luiscalleja11,

Which field are you checking in the length function within your expression? Can you share the expression?

[luiscalleja11 · Accepted solution]

Hi!
The solution I found is to run two times the Create/Update flow, because is recognizing the condition, but instead of only Creating the missing rows, is creating all of them, is the same with the update,

What I did is to set the configuration to "Unique values" To the SharePoint list, right now there are no more duplicated items, but needed to run two times the flow, one to check if there are missing rows and the second one if any of them needs an information update.

Thanks!