Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lu5AHzvPdZ4Ueb8gJFQRRj
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard