cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JartLig
New Member

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

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? 

 

1 REPLY 1
JartLig
New Member

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,364)