Unanswered

Need help with Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a problem. I had build a desktop flow for my organisation. When i start the flow, sometimes it works, sometimes it doesn't and there pop up a fail message.

In this flow i wanted to fill a Excel file with information. The app has sometimes a problem to read the aktive Worksheet. Can someone please help me.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share a screenshot of your flow? What does it do exactly? And also please translate the name of the action that fails to English.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Agnius,

thank you for your answer. The name of the action is called "Retrieve Active Excel Worksheet". The Subflow opens a Excel file and fills it with new information. Enclosed the entire Subflow:

Best Regards, sgk.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Are you sure your Excel file has a sheet with a name like that?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, because i call the active sheet. For example "table1". The programm safe that in the variable "sheetname". Than the program read the excel and safe the information in the variable "ExcelData". In the next step, the program adds the list to the variable "ExcelData". Then the program generates a random number and creates a new worksheet with the name of the number. The ExcelData variable is then written to this new worksheet. The old sheet (Table1) is deleted. When i open the code and click run it works fine. When i run the program from "outside" (see picture), it only works sometimes.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Where exactly in your flow do you set the %SheetName% variable? I cannot see it.

Was this reply helpful? Yes No