cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
godala_vamshi
Helper IV
Helper IV

Create or update from SQL to SharePoint list

 

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

godala_vamshi_1-1659140500984.png

 

godala_vamshi_0-1659140385344.png

 

Thank you! 

 

3 REPLIES 3
vivekpande18
Super User
Super User

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 

 

 

Thanks

Vivek Pande

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. 

godala_vamshi_0-1660851253920.png

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,912)