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)?
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 :
Its not recognizing the string as a valid parameter.
I've even separated the int() into a separate compose with the same outcome.
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:
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.
The new action uses Excel Online but even opening the online file and ensuring the columns were formatted appropriately the flow still failed.
I've been running some recent tests and I've found a formula that works on only some entries but fails on others.
Any other ideas?