Track Microsoft Forms response in Excel and notify through Teams and email

[JartLig]

Hi everyone,

I built a flow that works as follows:

1. When a new response is submited to a Microsoft Form

2. Get response details

3. Add a new row into an Excel Table

4. This Excel table consists of a few extra colums that calculates a score based on the answers submitted

5. Get row based on ID 

6. Send E-mail with the score calculated in the Excel

Now, the problem I have is that every time I submit a new answer on the form, I get an e-mail but the score will almost always be zero. Only when I test the flow some minutes later the actual score is sent via e-mail. It seems that when running the flow initally, the Excel is not updated in time so it just sends a score of zero. Does anyone have a solution for this? 

[JartLig]

Update:

https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-works-but-retrieving-zeroes-for-calc...
https://powerusers.microsoft.com/t5/Building-Flows/Excel-online-formula-not-calculation/td-p/200911

https://powerusers.microsoft.com/t5/General-Power-Automate/Excel-Get-a-Row-not-getting-formula-value...

I think this could be an Excel Power Automate bug that has been reported for a while but possibly not been fixed.

Similar issues have been reported multiple times but no real fix.

It seems once people go physically into the Excel and hit enter, then maybe the flow works as expected as extracts the values