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?
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
Thank you replying.
I will give your solutions a try. It makes sense to me now.
Much appreciated.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
User | Count |
---|---|
23 | |
12 | |
11 | |
10 | |
8 |
User | Count |
---|---|
33 | |
24 | |
22 | |
17 | |
16 |