Unanswered

Create a Data Table using variables and convert the same into Excel FIle

(0) Share

Report

Posted on by Sumitra_Sai

Hi, I need to create a data table by pasting the variable values for a row inside the table. After adding all the rows, the data table should be converted into an Excel file having column headers.

I'm able to create Data Table having variables as values. Now, I need to convert the data table to Excel Format.

Kindly help me to resolve this issue.

Thanks in advance for your help

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 sheet activity and give the data table as input
Put coloumn as 1
And row as1
If you want to append means
Then use get free row or column activity then get give getfree row variable as row in write to excel sheet activity
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 what you suggested. But could not get it as expected.
I

Was this reply helpful? Yes No
CU31080729-3 502 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,Sumitra_Sai
I am try this by creating manual data table and writing those data table into blank excel its working fine
may be you having issue in your data table or you can test by use blank excel and write your data into it and check it without saving your excel .

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
chetan ninghot

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

It just seems like your workbook is hidden. See here on how to un-hide it: https://excelchamps.com/excel-basics/hide-unhide-workbook/

I've seen it sometimes being caused by PAD. Usually works fine if you make PAD use a visible instance.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No