Answered

Capture Rows Count from Query Result

(0) Share

Report

Posted on by Waleed65

Hello Everyone

In PAD I’m trying to capture a Rows count to be used later in ( Conditional IF Action ) from ( Execute SQL Statement ) which the results shows in the Flow Variables as the screen below .

Annotation 2024-03-07 092432.png

so basically I need to learn how write the expression in the ( Conditional IF Action ) for example if the Rows Count greater than 43 go to next step .

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Waleed65 ,

Please find the below solution.

Code:
SET Excel_File_Path TO $'''\"C:\\Users\Desktop\\Power Automate Desktop\\Practice\\EXCELASDATABASE\\Input.xlsx\"'''
SET OLEDB_ConnectionString TO $'''Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%Excel_File_Path%;Extended Properties=\"Excel 12.0 Xml;HDR=YES\";'''
Database.Connect ConnectionString: OLEDB_ConnectionString Connection=> SQLConnection
@@copilotGeneratedAction: 'False'
Database.ExecuteSqlStatement.Execute Connection: SQLConnection Statement: $'''select *from[Employee_Personal_Details$]''' Timeout: 30 Result=> QueryResult
Database.Close Connection: SQLConnection
IF QueryResult.RowsCount > 43 THEN
Display.ShowMessageDialog.ShowMessage Message: QueryResult.RowsCount Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
ELSE
Display.ShowMessageDialog.ShowMessage Message: $'''GO TO NEXT STEP''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END

NOTE: Mark it as a solution if it works.

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Waleed65
You have the option to select any operator from the operator dropdown, which encompasses most of the necessary mathematical formulas such as:
Equal to
Not equal to
Greater than
Greater than or equal to
etc...
For more details with examples, refer the below MS document:
Use logical operations on conditional statements - Power Automate | Microsoft Learn
Using conditionals - Power Automate | Microsoft Learn

You can choose according to your business logic and proceed to place the next set of actions within the if condition.
If condition Operators
If condition:

Was this reply helpful? Yes No
Waleed65 21 on at

Like (1)

Report
Copy link

Link copied!

The expression ( %QueryResult.Rowscount% ) wrote in the First operand was what i needed exactly , thanks both of you @Deenuji @VishnuReddy1997 .

Was this reply helpful? Yes No