web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get data from run a qu...
Power Automate
Unanswered

Get data from run a query against the dataset and add into new rows in excel using Power Automate Schedule flow

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

We are using a scheduled flow in order to send emails with an excel(.xlsx) file as an attachment. Currently, we were able to pull the data using 'Run a query against the dataset' with a query containing CALCULATETABLE() function.  However, we want to insert the output from this step into new rows in an excel file. We have tried adding the data into csv table first and then inserting the data into excel. But the data is getting inserted only in the first cell(which is not correct). 

We would like to insert the data from 'Run a query against the dataset' into new rows in an excel file. 

Someone kindly suggest a way to achieve this.

Thanks in advance. 

Categories:
I have the same question (0)
  • TonyO Profile Picture
    15 on at

    Hi there,

     

    Did you find a fix? I'm having the same problem amd have been searching for a solution...

     

    Regards,

     

    Tony

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard