Excel Get a Row not getting formula values

[PeerPower]

Dear All, 

Hope you're fine. I am new to Flow and faced a problem which I am sharing below:

I have using Flow for almost a year now. It was working well until suddenly the get a row connector in my flows stopped getting formula calculated values. In Get a row connector, all the connections are valid. It also take all the plain text values, but for the values which are formula based, it just shows empty, #NA, 0, 1 etc.

In short it is not taking formula based values or the formulas in there are not getting calculated... Any help please.

I use Excel Online (Business) connector.

[nothere]

I have the same problem, flow working fine until july, then stopped retrieving calculated cell values. The only update in the connector i could find, which could have affected the behaviour of this application, is the introduction of the office scripts.

I don't know if that is a new intended behavior for 'get a row' or something else, the functionality can be replaced withs 'list rows' and a OData filter, but i ran a test and also failed to retrieve calculated column data.

Did you find a solution?