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)

UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

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 (0)

Report

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 203 Moderator on at

Like (0)

Report

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 (0)

Report

Thanks @UshaJyothi20

Was this reply helpful? Yes No