Power Platform Community Forum Thread Details

Hello,

Sorry for my terrible English.

I was asked to do this by a distant friend.

Despite it running successfully in my environment, it fails in his environment.

His OS is Windows 11, and PAD is the latest version, exactly the same as mine.

I’m using two flows, main and sub, and the process flow is briefly described below.

Main

User chooses a folder, say InputDirectory

Sub

Launch Excel
Find xlsx files in InputDirectroy and open them in a loop
Store the first column data of each xlsx file in a list variable “List”
Remove duplicates in the List
Write List to a blank Excel worksheet(Error occurs)

An error occurs at the very end of the sub-flow.

So, I created the following flow and had it run in a friend's environment. Then, no error occurred.

Experiment

User chooses a folder
Launch Excel
Write “test” to Excel worksheet
Save the Excel document

Why do errors occur in his environment that do not occur in mine?
Also, why do errors sometimes occur when writing to an Excel worksheet in his environment and sometimes not?

Attached is an image of the error. Thank you.

Categories:

Power Automate Desktop

Community site session details

I am getting errors when writing to Excel worksheet.

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates