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 / Trying to run a sql qu...
Power Automate
Unanswered

Trying to run a sql query and create or update an excel file with the results

(0) ShareShare
ReportReport
Posted on by 2

Pretty much says it all in the title - I'm trying to schedule a sql query and then create a new worksheet in an excel file and have it update based on the results.  Below are my rough steps but will probably have more questions once I understand the high level order of the steps. 

 

zwiddoss_0-1611699550730.png

 

Categories:
I have the same question (0)
  • manuelstgomes Profile Picture
    6,625 on at

    HI @zwiddoss 

     

    I think your structure is almost there, but I would recommend putting the "create table" outside the "Apply to each". You don't want to create a table for each row. You want to create a Worksheet, a table, and then fill in the values in that table, correct?

     

    What other issues are you getting?

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    Cheers
    Manuel

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard