Error getting values from excel formulas

(0) Share

Report

Posted on by naiani

Hello

I'm building a flow for an online test in my company.

I've got the forms aswers going to an excel file on a group sharepoint (via forms for excel, no steps on flow involved), and I've added columns with formulas that check the aswers and calculate the final grade.

Problem is that when geting the row's value, the columns with formulas are all inputed as "0" in flow

Here's some screen prints of the tests

Values that flow are geting form columns that are formulas as "0"

Excel file with some columns with formulas

Flow steps until error

Appreciate the help, couldn't find anything like this searching the Community.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Hi @naiani,

There is post with the same issue, it seems the calculate column sometimes will invalid:

https://powerusers.microsoft.com/t5/Building-Flows/Excel-online-formula-not-calculation/m-p/200911

As a workaround, it's recommended that store these data into the SharePoint list, there calculate column could work normally and stability.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
naiani 18 on at

Like (0)

Report

@v-litu-msft thank you! It worked perfeclty with a sharepoint list

Was this reply helpful? Yes No