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)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@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

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