web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extract Data List Colu...

Power Automate

Answered

Extract Data List Column to Row

(0) Share

Report

Report

Posted on by asakki13

9

How to transpose extracted data from web page (Column) to write to excel in row.

output will be as in excel

306.00 586.00

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @asakki13 ,

I've made a test for your reference:

Variables.CreateNewDatatable InputTable: { ^['#', 'results'], [0, 306.00], [1, 586.00] } DataTable=> DataFromWebPage Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance SET loopCount TO 1 LOOP FOREACH CurrentItem IN DataFromWebPage SET NewVar TO CurrentItem Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CurrentItem[1] Column: loopCount Row: 1 Variables.IncreaseVariable Value: loopCount IncrementValue: 1 END

Best Regards,

Bof

Was this reply helpful? Yes No
asakki13 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much

Was this reply helpful? Yes No

Join the conversation