Flow pulling numbers as strings from excel table

[MarioA43]

Hello everybody!

So, i've been working on a project for some time and built a flow that is supposed to do the following:

1)gets some information from AI builder, because AI builder treats everything as text, so the flow gets these string values.

2)throw these values into a table in excel where they're formatted as numbers.

3)proceeds to pull the values in the correct format and input them in a list in sharepoint.

However, when the flow get the values from AI builder and place them in the sharepoint list, despite the values being considered numbers within excel (=isnumber outputs "TRUE"), the flow pulls them out as a String, one which can't be converted to float using expressions( Have tried). so i'd like to know if anyone can help me identify:

1)why does the workflow pulls out the values as Strings despite they being classified as numbers within excel.

2)If there's any other method to convert these values from strings to floats.

P.S. The values are accounting numbers that follow the format 99.999,99 so i believe the dots and commas prevent the conversion from string to float.

Thanks in advance!

Problem images below:

1.Trigger and basis.

2. the error.

[MarioA43 · Accepted solution]

Well, turns out it is some kind of bug with the excel for business connector, i found a way around it.

in case someone is interested, the Value pulled from the excel for business is classified as a String, and what i did was, i created another column in the sheet with a =Value() formula that pick up the "String" that is considered a number and turns it into a number one more time (Yes, i "converted" it into itself), in that way the value pulled by Power automate is able to be converted to a float(couldn't be done before due to the commas and dots in the string).

Pic of the solution working:

1. "converting" the number into itself

2.turning it into a float.

and voila! the numbers are converted into floats and are ready to be input into a sharepoint list!

[alrez]

Hi,

Thanks for your follow up post! I am glad that you were able to discover a workaround for this issue and post a follow up here. Hopefully this will prove useful for future communities users.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Harindu973]

Hi MarioA43,

    Is this bug only in Business connector? How about Excel Online(Onedrive)