Power Automate 'Get Row' Excel returning #Value! rather than cell content

(0) Share

Report

Posted on by mattrmelb

Hello,

Any thoughts on this:

Set up a Flow to get the contents of a row on an Excel Sheet and then copy them over to another table within the same workbook.

Flow finds the row without issues, but a couple of the cell values are returning #Value! when they have data. The cells are using a mix of the AVERAGE and COUNT forumlas to populate the cell, flow is able to get the correct value from one cell using AVERAGE and one cell using COUNT, but the two other cells using AVERAGE are returning #Value!.

All 4 Cells have data and are formatted the same, i.e. Number format.

Table:

Cells with Data

Formulas:

Formulas

Output of Flow:

Flow Output

Any help would be apreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

PrasadAthalye on at

Like (0)

Report

Are you saving those values from this flow? Also, All the columns that are used in the functions, are they formatted as int?

Was this reply helpful? Yes No
mattrmelb 2 on at

Like (0)

Report

Hi @PrasadAthalye thanks for responding.

>Are you saving those values from this flow?
The intent is to add the values into variables, that will come after the 'Get Row' step of the Flow.

>All the columns that are used in the functions, are they formatted as int
Yes, have tried a combination of 'General' & 'Number' formatting. Further to that I have checked that the table that the function is referencing to do the calculation all have the same formatting.

Was this reply helpful? Yes No
DEIVITY 2 on at

Like (0)

Report

I had a problem of this type and after changing the regional settings of Excel Online to English (United States) I had to change the Excel Online formulas that dealt with dates and Power Automate returned the values instead of the error.

Was this reply helpful? Yes No