Answered

How can I check if a row is present or not in a datatable?

(0) Share

Report

Posted on by CU-19081228-9

Hello Everyone.

I want to be able to check if a row is present in a datatable and, if it isn't, do something.

I use IF MyDataTable[1][0] <> 'Null' (I also tried the Is Empty option), but it doesn't seem to work and gives an 'Index is out of range' error if the row doesn't exist and the flow stops.

How can I check if data exists in MyDataTable[1][0] exists or not and then do something?

Thank you for any help.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @ianwuk ,

Try %MyDataTable.RowsCount% or %MyDataTable.IsEmpty%

Here is a sample flow:

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much for your help @Kaif_Siddique

Was this reply helpful? Yes No