Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

How to convert text file to excel

Like (0) ShareShare
ReportReport
Posted on 15 Nov 2019 06:19:33 by 34

Hi,

I want to make a flow that when a text or csv file adds to SharePoint, convert it to excel or add the content to a Sharepoint list

The text file rows are like:

02;E02;A-0192;10,000;10,000

so I need to set each part in a column. 

 

Would you help, please?

 

  • Verified answer
    v-bacao-msft Profile Picture
    on 19 Nov 2019 at 07:24:02
    Re: How to convert text file to excel

     

    Hi @Setayesh ,

     

    Because Do until creates up to 60 loops.

     

    You can consider using Apply to each instead of Do until.

     

    Create an integer variable, each time the variable is incremented, and determine if the expected value has been reached. If it is, then the action that is expected to be executed is not executed.

     

    Hope it makes sense.

     

    Best Regards,

  • Setayesh Profile Picture
    34 on 18 Nov 2019 at 12:30:27
    Re: How to convert text file to excel

    Hi, 

     

    Many thanks for the respond, I tried that. I need to check each row but it just can get the first 60 rows and I dont know how to fix it. the rows are more than 30000.

     

    the file data is like bellow now: just necessary data kept in csv file

    A-0129
    A-0134
    A-0247
    A-0281

     

    1.jpg2.jpg3.jpg

     

  • v-bacao-msft Profile Picture
    on 18 Nov 2019 at 02:39:29
    Re: How to convert text file to excel

     

    Hi @Setayesh ,

     

    Please check this image:

    108.PNG109.PNG

    Best Regards,

  • v-bacao-msft Profile Picture
    on 18 Nov 2019 at 01:04:29
    Re: How to convert text file to excel

     

    Hi @Setayesh ,

     

    You can use Get file content to get the file content first. The file content of the text file should be plain text.

    Then use the split() function to split the content.

    Finally, use the array index to reference the value of each element and add it to each column.

     

    Best Regards,

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 212 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 208 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 186

Overall leaderboard
Loading started