Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

Using Integers from an Excel Get Rows

There have been some updates to the Excel Get Rows actions. I used a function to calculate the inverse of a column and update a sharepoint list with the new (now positive) value. 




In the last month since I used that formula some updates were made that changed the way Flow recognizes this column and now pulls as a string instead of an integer.


Is there an fix for this while MS tries figure out how to recognize a column thats fomatted as a number (currency, amount, ect)?

Community Support
Community Support

Hi @crf200,


Do you want the Amount column in excel table to be seen as number type?


I have made a test on my side, if you want the Amount column in excel table to be seen as number type, you could add a int() expression beside the expression of the Amount column, and the expression on your side should be :



Best regards,


Hi Alice,


Int Capture.JPG






Its not recognizing the string as a valid parameter.


I've even separated the int() into a separate compose with the same outcome.




Hi @crf200,


Please don't rename the Apply to each on your side, I afraid that the expression in invalid for you have rename the Appply to each with wrong formate name.


I have made a test on my side, the screenshot of the flow as below:



The expression in the Condition as below:


The flow would run successfully as below:




Best regards,




I completely redesigned the flow as it worked for some list items but would fail on others when it was built just like that. I saw the new 'List Items from Table' that connects with Sharepoint Online so adopted it on the rebuild so other members of my team can also have access to the files.Capture 1.PNG






The new action uses Excel Online but even opening the online file and ensuring the columns were formatted appropriately the flow still failed.Capture.PNG




Advocate III
Advocate III

I've been running some recent tests and I've found a formula that works on only some entries but fails on others. 


mul(int(items('ATE2')?['Amount']), int(-1))

Any other ideas?



Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

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!

Top Solution Authors
Top Kudoed Authors
Users online (9,636)