Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get Rows V2 SQL to Update SharePoint List Problem

Hi all


I am pretty new to Power Automate and learning quickly due to the great resources and posts on here.


One issue I am having but I think a pretty simple one is this.


I have a flow that first gets rows from a SQL view.  All the fields in the source SQL view as string values including a field called Title


From the Get Rows, I then am trying to update rows in a SharePoint list where Title from GetRows equals Title in SharePoint list.


I have done this by using SharePoint Get Items first in an Apply To Each where the SharePoint Title eq Title from the output of the GetRows (before I then do an Update List items).


Since the Title field holds values as examples 20089882, 20663644, 29882726-2 it is assuming that these are integers and when it comes to processing one with the -2 in, it complains that it is not an int.


How do I get the output from SQL to make sure it converts the Title into a string in the output.  I know the output from the GetRows is dynamic but I want to ensure the output variable is string values.


Can anyone describe how to do this?

Solution Sage
Solution Sage

you can intialize a variable of type string and whatever value you give in it will convert it to a string. Please make sure to itnalize the variable outside the apply to each loop and use set variable in loop.


or you can use this function 

string(SQL Title Value) when comparing 
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.




Frequent Visitor

Thank you replying. 

I will give your solutions a try.  It makes sense to me now.


Much appreciated.



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (5,520)