You’re offline. This is a read only version of the page.
2
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?
Hi, I updated my question after looking into it a little more and provided a screenshot. Your help would be greatly appreciated! https://powerusers.microsoft.com/t5/Process-Advisor/Office-Script-Errors-With-Function-That-Has-While-Loop-and/m-p/2019936
Can you post your script and an example of a workbook with the formulas that you're using so that we have a better idea of your scenario and are able to reproduce the issues ourselves?
Share
Report
All responses (
Answers (
