Hi, I am trying to Create or update from SQL to SP list using a Flow. Update works fine but it doesn't create new items even though SQL have new items. Any mistakes in my setup below?
Condition expression : length(outputs('Get_rows_(V2)')?['body/value'])
Here is my setup
Hi @godala_vamshi ,
You need to change your condition comparator.
In your condition, you are checking if
Length is equal to 0 ,
Instead you need to check if
Length greater than 0
Hi @vivekpande18 , Thank you! after updating it is creating but it is creating a duplicate for each item.
But I was able to handle this by setting up to accept only unique ID's in SP list.
@vivekpande18 Thanks again for you help, Can you tell why data is not updating? It runs fine and creates new items but some how its not updating the existing data.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.