Skip to main content

Notifications

Community site session details

Community site session details

Session Id : DT/+WNYufrgok/ACEUX7QN
Power Automate - General Discussion
Unanswered

schedule a daily sql query, send email with results

Like (0) ShareShare
ReportReport
Posted on 27 Feb 2024 14:18:05 by 2

Hello everyone,

my first post here, I believe. Just getting started with powerautomate. I run a SQL query every morning. It is an ORACLE database I am querying. I would like to schedule a flow to run the SQL query every morning and email me the results as a .txt or excel file, no preference, as long as I get the results lol.

Any guidance is much appreciated by this newb.

resko

 

  • RESKO Profile Picture
    2 on 29 Feb 2024 at 16:29:49
    Re: schedule a daily sql query, send email with results

    Thank you for your suggestion...However, when I put SQL instead of the sharepoint action(like you do) it is asking for into that I do not have at the moment...server name

    Also, the SQL option is under SQL Server, and we have ORACLE server, not SQL.

  • SudeepGhatakNZ Profile Picture
    14,318 Most Valuable Professional on 27 Feb 2024 at 22:33:16
    Re: schedule a daily sql query, send email with results

    @RESKO 

    Swap out the Get items SharePoint action with its SQL equivalent.

    Feel free to tweak or expand upon it further based on your specific context or requirements.

    SudeepGhatakNZ_0-1709073139789.png

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
David_MA Profile Picture

David_MA 8 Super User 2025 Season 1

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

Overall leaderboard
Loading complete