Power Platform Community Forum Thread Details

I'm using Office Scripts with Power Automate to transfer data between two Excel files. Here’s the scenario:

'Run script' to copy data in Excel file on Sharepoint: Script reads a range from the source file and returns a 2D array as partialData1.
'Run script 1' to paste copied data into different Excel file on Sharepoint: Script expects partialData1 as an input parameter.

The copy script works correctly (verified via Compose and Parse JSON), but in the Run script action for the paste script, only basic fields (location, document library, file, and script) appear. The advanced parameter for partialData1 isn’t showing, causing the paste script to fail.

Based on a forum suggestion, I removed the explicit return type from the copy script so that it returns the object without a defined type. Unfortunately, this did not make the advanced parameter appear.

Excel Online (for business), Outlook, and SharePoint all show 'connected'. The only thing I could think of is that my permissions level shown in Power Automate says "maker without full data access", which sounds like my account might not have access to share data between files. However, 'update a file' works for me, as well as a test flow of Excel 'list rows present in a table' and Excel 'add a row into a table' where the data is moved successfully between the 2 files.

Has anyone encountered this issue? Is this a known limitation or bug with the Excel Online (Business) connector? Any suggestions or workarounds would be appreciated.

Categories:

Building flows

Hi,

How did you set up the parameters for main() function in Excel for the script used in the Run Script 1? In general, if the parameter is not visible in Power Automate, it's likely some issue when setting it up in your Office Script.

I had some similar issues in the past and solved it by changing the type of data expected as input to an object format. For example, instead of set the parameter to partialData1:string[][], I set obj:object, and passed the data to be pasted like this in Power Automate: {"partialData1":[your_partialData1_dynamic_content]}

For those who find this thread in the future and want to learn more on how to send data from Power Automate to an Office Script, refer to this article: https://digitalmill.net/2024/01/17/sending-values-from-power-automate-to-excel-with-office-scripts/

Let me know if it works for you or if you need any additional help!

If this is the answer to your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

Check more Power Platform content on my website.
Lets connect on LinkedIn.