Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

SharePoint Number List item will only store in string variable

I am buiding a Flow that pulls the Employee_ID from a Number column in a SharePoint list, stores it ina variable, and compares the variable to the Employee_ID column in another SharePoint list in the same site. I have run into several problems attempting to this simple action;

When initalize the variable as an Integer or float the flow errors out. The only way I can store the Employee_ID to a variable is if the variable is intialized as a String.

Secondly, the condition NEVER evaluates as True. When I checked the outputs of the variable it always is employee_id with the characters cxz added i.e. 123cxz  When Flow takes this value and compares it to the Employee_ID in the second table it looks as though Flow is comparing to the original value minus the cxz characters.


Is the Number column type always considered to be a String by Flow?


Do I need to convert the value with some function to remove the cxz characters prior to storing in the variable?

Helper I
Helper I

Solved issue NO NEED TO REPLY

Hi @lmartini,


I am glad your issue has been solved. If convenience, you could go ahead post your solution and mark your post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (34,258)