schedule a daily sql query, send email with results

Like (0) Share

Report

Posted on 27 Feb 2024 14:18:05 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

All responses (2)

Answers (0)

RESKO 2 on 29 Feb 2024 at 16:29:49

Like (0)

Report

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 14,318 Most Valuable Professional on 27 Feb 2024 at 22:33:16

Like (0)

Report

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.