Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Excel Script issue Power cloud Automate and Power Apps Application Running

(1) ShareShare
ReportReport
Posted on by
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.

 

Under review

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard