I made a flow in Power Automate that will run a script from a SharePoint Excel spreadsheet. This script will copy the values I have in a summary tab and paste them elsewhere. The script works normally when run manually. However, when it runs through Power Automate, it runs but the results get messy. It pastes some values but the rest is pasted with error, as shown in the attached print (comparing the original value and the values that were pasted after the script ran).
It is worth mentioning that these values in my consolidated data come from a database that is connected via the power bi connector.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.