Problem Execute SQL Statement

(0) Share

Report

Posted on by Wendy-Zheng

Dear all,

i am using Power Automate Desktop to analyze excel data by SQL, but having problem when Execute SQL Statement:

after running the flow, there is no data in QueryResult (see highlight in below picture), is it normal? or is it a failure? i am not sure because there is no issue alert during flow running. could anyone give some suggestions? thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (16)

Answers (1)

Sort by

Srini007 3,473 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wendy-Zheng

Can you check in the SQL table, whether you have the data or it is empty?
If data is empty then that is correct

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini

Was this reply helpful? Yes No
Srini007 3,473 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wendy-Zheng

try writing query as SELECT * FROM TABLE1

For more reference you can check below link

https://learn.microsoft.com/en-us/power-automate/desktop-flows/how-to/sql-queries-microsoft-access

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini

Was this reply helpful? Yes No
Srini007 3,473 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wendy-Zheng

Check below documentation for Excel file

https://learn.microsoft.com/en-us/power-automate/desktop-flows/how-to/sql-queries-excel

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini

Was this reply helpful? Yes No
Wendy-Zheng 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Srini,

After check, the SQL Testing excel file has data like below (1st picture). So I tested the connection of SQL and it reported an error (2nd picture), is it the cause of empty QueryResult (no SQL connection)?

Was this reply helpful? Yes No
Wendy-Zheng 20 on at

Like (0)

Report
Copy link

Link copied!

Thanks Srini,

I tried with this code and run the flow again. Similarly, there is no alert/error during flow running but the QueryResult is still empty.

Was this reply helpful? Yes No
Srini007 3,473 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wendy-Zheng

Did you install the below Redistribtuable?

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini

Was this reply helpful? Yes No
Wendy-Zheng 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Srini,

Yes, I have installed it and the engine can be found in the Provider in Power Automate.

Was this reply helpful? Yes No
Srini007 3,473 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wendy-Zheng

1) Check the connection string is as below
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%Excel_File_Path%;Extended Properties="Excel 12.0 Xml;HDR=YES";

2) In Execute sql statment write as
SELECT * FROM [SheetName$]
SheetName->Replace that with your excel sheet Name

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini

Was this reply helpful? Yes No
Gidi 601 on at

Like (0)

Report
Copy link

Link copied!

Hi,
seems you are on the right path (Configure a connection string manually)

Do you really have blank password for User ‚Admin‘?

Get the last error action result for more details of the problem.
Try further with Error Handling of the used actions to find the root cause.

Was this reply helpful? Yes No
Verified answer

Srini007 3,473 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Wendy-Zheng
Tried this below are the steps

1) Installed the Redistruable of 64x
2) Copied the connection string and it worked

You copy the steps below and paste to the PAD

SET Excel_File_Path TO $'''D:\\PRODTriggers.xlsx'''
Database.Connect ConnectionString: $'''Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%Excel_File_Path%;Extended Properties=\"Excel 12.0 Xml;HDR=YES\";''' Connection=> SQLConnection
Database.ExecuteSqlStatement.Execute Connection: SQLConnection Statement: $'''SELECT * FROM [Triggers$]''' Timeout: 30 Result=> QueryResult

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini

Was this reply helpful? Yes No