Power Platform Community Forum Thread Details

Dear Team,

I am currently working on a solution involving PowerApps and Power Automate, where I am passing an Excel file from an EditForm in PowerApps. Upon clicking a button, the workflow in Power Automate triggers to:

1.Create an Excel file in SharePoint from the uploaded file.

2.Execute a script to process the Excel file by:

•Removing blank rows at the beginning of the file.

•Creating a data table.

•Renaming the sheet and table to a standard name for further processing.

The workflow performs as expected during testing in the Power Automate environment. However, when attempting to upload the file through PowerApps, the workflow fails with the following error:

“We were unable to run the script. Please try again. The script couldn’t create a connection with Excel. Please try again.”

We have explored multiple approaches but have been unable to resolve this issue.

Could you please assist in identifying the root cause of this error and suggest any alternative solutions to achieve the desired outcome?

Thank you in advance for your support.