Answered

Trouble Building Flow to Paste File Contents to Existing Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am new to designing flows. I am trying to create a flow that will copy a text file from a folder that is in table format and paste it into an existing Excel document. Currently I am stuck that only the top row of the text file will paste so I tried a for each loop with no luck. I have pasted a current state of my flow below for reference. Any advice or resources would be greatly appreciated!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Try Launch Excel, and use the text file as the filename. This will prompt Excel to open the text file, it should open correctly, and you won't have to write it to excel.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I didn't think of that, thank you! Do you know of a way to select a whole column in the Excel sheet? It gives an error if end row is not filled out.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

%FirstFreeRow - 1%

Math on a variable has to go inside the % sign.

Was this reply helpful? Yes No