News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows text file to excel

Power Automate - Using Flows

Unanswered

text file to excel

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi,

I have a file in my o365 with attachment and the data looks like this.

pe1ustsxftp01.pcisso.global-10.222.29.10 is available.

It doesnot have headers.

I need to push the data to a excel file using flow.

my requirement looks like this

Yellow Color highlighted are my headers.

Please help me.

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: text file to excel

@abm ,
Yes it has similar lines with same format.
I need to use (.) as delimiter
Thanks
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: text file to excel

Hi @Anonymous

You mentioned about you have a text file as the data is in format as below

pe1ustsxftp01.pcisso.global-10.222.29.10

Believe there are multiple lines of the similar text as well.

So you want to read the text file and insert the values into Excel Sheet.

Is that correct?

Thanks

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,653 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans