cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JanekM
New Member

Sharepoint list updated from sql view

Hello Everyone

I try to update Sharrpoint list with data from SQL view. I have correct data from Sharepoint and SQL, and flow not working, not updating, not creating. I tried to inialize variable, and compare strings, but it also doesn't work.

Can anyone help me?

Best regards

Janek

JanekM_0-1624878256740.png

 

5 REPLIES 5
annajhaveri
Community Champion
Community Champion

@JanekM  can you please share the screenshot of  flow run with all actions expanded to know what is going wrong in the flow?

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

@annajhaveri  thank you for your interest in this topic. Below is expanded flow. I think, the problem is condition, I tried to use string expression or initialize string variable, but it doesn't help

Best regards

Janek 

JanekM_1-1624891326811.png

 

 

JanekM_2-1624891362587.png

 

annajhaveri
Community Champion
Community Champion

@JanekM  thanks for the screenshot, could please help with screenshots of your flow run, also what will be the value of Title and Numer field that you are using in the condition?

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

@annajhaveri in run I can't expand most interesting part 😕

In condition I compare two strings. Something like that FSK 2021/05/0197. I tried to compare directly, I tried to compare after convert to string. 

JanekM_0-1624953899274.png

 

annajhaveri
Community Champion
Community Champion

@JanekM from the flow run screenshot it looks like records are returned from SharePoint Get Items action, If you see flow run, you see apply to each shows 132 count, but there is no count for Apply to each 2, and Apply to each is using value (list of items) from Get Items. So please check if Get Items is returning items. Also please share screenshot of Get Items with advanced options open.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

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.

Users online (3,809)