A script containing a while loop apears to have different functionality when ran through power automate. The code enters random numbers into a cell to refresh a random sampler function. The while loop will continue to edit the cells until the shuffler meets the conditions required to be true. I entered console.log() methods in the code to verify the condition is being met and it appears to be working. However, the output result does not meet conditions and the excel workbook only seem to update once.
The code run as expected in excel but when running the script through power automate there seems to be a syncing issue between the script and the data. Any ideas on how to fix this?
