Get row from excel can't read formula data

[Cim]

Hi there

I'm trying to analyze the responses on my form, and then email them back to whoever responded. And for that I use some formulas in Excel, the problem is that when I try to get the columns that have formulas, it goes wrong. In most columns I just add two form values and divide by 2 (an average without the formula), and in these columns I always get a 0, but in other columns with more complex formulas like, "sum", "index", "if" and "match" is returned an error, as in the following screenshot (the red line separates how far the form's responses were, and where the Excel formulas are):

This is a screenshot of how it looks in Excel, and this is what the results should look like:

Apparently my problem is the same as this user, but I didn't understand how he solved it.

And in case it helps to understand the problem, this is how my flow works, I still added a delay before getting the Excel line, but the error persists.

Thanks!

[Michael_Yen]

I experienced similar issue with the " Get A Row" Action steps. The Excel worksheet with formula values were not retrieved. I also added Delay Action step without success

My data source was a MS Forms created in MS Teams and the Forms Excel Worksheet was in MS Teams .

If I connect the MS Form to another Excel Worksheet ( via Adding a Row Action Step followed up Get a Row Action STep) in the MS Teams with similar formula, the flow retrieve the Formula values successfully.

Based on my experience, Flow can retrieve values from another worksheet which stores the MS Forms responses but not the default Form Responses worksheet in MS Teams.

Would be helpful if some experienced user could advise further.