Unanswered

schedule a daily sql query, send email with results

(0) Share

Report

Posted on by RESKO

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
RESKO 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No