web

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

Power Platform CommunityForums Power Automate - Power Automate Desktop How to write Data from...

Power Automate - Power Automate Desktop

Answered

How to write Data from Table/Variable into Excel

Like (0) Share

Report

Report

Posted on 21 Oct 2022 14:59:21 by MW-03071424-0

Hi,

i created a DataTable (with "Read from Excel") as a Flow-Variable. I want to rearrange that data and put it into a new Excel Sheet.

DataTable in Power Automate:

How i want to insert it into Excel:

Is there a way to do this?

Thanks a lot in advance!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Jamar_Forsythe Microsoft Employee on 21 Oct 2022 at 16:46:44

Like (0)

Report

Re: How to write Data from Table/Variable into Excel

Currently there doesn't exist a way to do this is PAD without a series of actions. Please submit your suggestions and feedback in the Feedback Hub

One approach is to take each column and split it into a list using the "Retrieve Datatable column into a list" action, then paste each list in the order you want them into the Excel Spreadsheet

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 655 Super User 2025 Season 2

#2

Tomac 371 Moderator

#3

chiaraalina 276

Last 30 days Overall leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts

List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans