Unanswered

Create a new Excel file from already existing file

(0) Share

Report

Posted on by Sumitra_Sai

I have an excel file having some sheets like below. I'll ask the user which sheet he wants. Then what are the columns you need in the new Excel File. eg. In my excel, I ask the user to select between Name, Code, DOJ, Designation. If he selects Name and Code column, then that should create a new Excel file having Name and Code value and saves accordingly.

So what I did was, i created a list which stores the user selected columns. I'm stuck after that on how to check.

Kindly help me in resolving this issue.

Thanks in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Use write to Excel worksheet activity and give the list as input
You can create a new worksheet manually and give that path or you can directly select the location and give the name so that the new excel sheet will be created automatically.

Hope this helps,
Usha

Was this reply helpful? Yes No
Sumitra_Sai 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @UshaJyothi20 , thanks for your reply.

I tried as you suggested. But didn't work. And I also need the values of those columns to be extracted from input excel and copy to output excel
Kindly help me to resolve this issue
thanks in advance

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try this method i have tried writing list in Excel

Hope this helps
Usha

Was this reply helpful? Yes No
Sumitra_Sai 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @UshaJyothi20

Was this reply helpful? Yes No