Answered

How to judge whether the variable named datatablematches is empty

(0) Share

Report

Posted on by tanhu

The PAD flow and running results are shown in the picture. There is no data matched ExcelData1 in table, so the table named DataTableMathcer2 is empty. I set a series of variables to check whether the table 'DataTableMathcer2' is empty. But they don't work.

Ask for your help, thanks a lot!

PAD flow and results

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Use a conditional action like an If like this:

You can either check if %DataTableMatches.IsEmpty% equals to %True% or if %DataTableMatches.RowsCount% equals to 0. Both will indicate the table is empty.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Use if condition
then give first operand as datatable variable
and second operand as %""%
As shown below
Hope this helps,
Usha.

Was this reply helpful? Yes No
tigerhuzi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank for your reply, but they both don't work. Which %DataTableMatches.RowsCount% equals to 0 means NewVar4, and DataTableMatches.IsEmpty% equals to %True% means NewVar5.

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

You should not use Set variable for your conditions. Use an action called If to do a conditional statement. When you do that, you can then make your flow take appropriate action inside the conditional statement when the condition is true.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No