Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Automate - General Discussion

#1
stampcoin Profile Picture

stampcoin 23

#2
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#3
Gprior Profile Picture

Gprior 19

Overall leaderboard
Loading started