Building a flow that ask for the filename and retrieves data from an excel sheet

(2) Share

Report

Posted on by fredrikWick

Hi!

I've been looking around but can't find the solution.

I have a template in which data is created. The same template is used in many different projects and I want to be able to extract the data from one row and paste it into another excel sheet.

So - I want to:

Manually trigger a Flow
Navigate to a folder with an excel sheet
Copy the data from one specific row the excel sheet
Paste the row into another excel file.

Is this possible? - and how?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Dominik Stalzer | p... 71 on at

Like (0)

Report
Copy link

Link copied!

Create a Manually Triggered Flow

Add a new step: List rows present in a table."

Select the file and the table containing the data.

Add a "Filter array" step:

Use the output from the previous step to filter for the specific row you want to copy.

Add a new step: search for "Excel" and select "Add a row."

Choose the destination file and the table where you want to paste the data.

Map the columns from the filtered row to the corresponding columns in the new file.

Hope this helps

Was this reply helpful? Yes No
tolga-balci 72 on at

Like (1)

Report
Copy link

Link copied!

I have the same question.

@Dominik Stalzer | primeone - the answer you provided is fine, but I don't think that it answers the question completely. The question is for the Power Automate to "ask for the filename" and then act on the select file.

Was this reply helpful? Yes No
Dominik Stalzer | p... 71 on at

Like (0)

Report
Copy link

Link copied!

@tolga-balci
Create a Manually Triggered Flow

Add a text input to the manual trigger:
Let the user type in the filename (e.g. “projectdata.xlsx”).

Add a "Compose" step:
Use the filename to build the full file path (e.g. /Shared Documents/YourFolder/@{triggerBody()['text']}) if it's stored in a known folder.

Was this reply helpful? Yes No