cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeerPower
Regular Visitor

Excel Get a Row not getting formula values

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.

1 REPLY 1
nothere
New Member

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?

 

 

 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (65,198)