web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Files in Folder

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello All,

I am using "Get Files in folder" action which populates a list variable "Files". When I attempt to write the list into an Excel "Write to Excel Worksheet", I don't get all the file paths inserted into Excel.  The reason is likely that the filepath together with filename is too long to fit in Excel Column. 

I attempted to use "Write to CSV file", the files in list variable are separated by comma and thus attempt to show in a single row.  I am trying to get all file paths in a single column. 

 

Any help or ideas appreciated!

Thanks.

I have the same question (0)
  • Verified answer
    VJR Profile Picture
    7,635 on at

    Hi @Anonymous 

     

    Total number of characters that a cell can contain are 32,767 characters 

    Excel specifications and limits (microsoft.com)

    So its doesn't look like that is the issue.

     

    When you mention "..I don't get all the file paths inserted into Excel. "..

    What do you actually get?

    Can you check the length of how many characters are present in that cell after writing.

    You can use the below formula manually, where A1 is your cell after writing from PAD.

    =LEN(A1)

     

    Check with different folder paths and see if it is always trimming after a certain number of characters.

     

    One thing I noticed is when I wrote the %Files% variable directly as below...

    VJR_0-1634791126012.png

     

     

    Then it wrote the list of files on separate cells starting from A1, A2 and so on.

    VJR_1-1634791292315.png

     

     

    But when I set the list of files first in Clipboard and then wrote the Clipboard to the Excel...

    VJR_2-1634791382791.png

     

    Then it wrote all of the list within one single cell....I think this is what you want.

    All of them were written within only A1.

    VJR_3-1634791632584.png

     

    In my case when I checked the length of this cell, it did not exceed 32,767 characters.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you VJR. You are right. Excel cell can contain a lot of characters (32,767).  It could be some glitch on my PC / instance.  After reading your response, I tried using "Write to Excel worksheet" again and I got the same count as in the list variable "Files". 

    Thank you again for your help & prompt response. 

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 378

#2
Valantis Profile Picture

Valantis 329

#3
David_MA Profile Picture

David_MA 283 Super User 2026 Season 1

Last 30 days Overall leaderboard