Unanswered

Need to check if record is selected in DataTable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I need to be able to check whether there are no records currently selected within my datatable. I can't use the IsEmpty function because the datatable technically is populated, it's just that sometimes when I toggle on my Filter() function is run, no records are displayed, and I need to be able to detect this within my app.

Is this possible?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

wyotim 2,545 on at

Like (1)

Report
Copy link

Link copied!
Hey @Anonymous, have you tried:

IsBlank(Datatable1)

In doing some messing around with a datatable filter, this worked for me. You could also use a CountRows function on the Filter statement to check as well.

Feel free to let me know if that helps or needs more explanation!

*edit for spelling error*

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to check if there are no records selected within the Data Table?

In default, the first record within the Data Table would be selected, there is no way or function supported to unselect the record from the Data Table.

If you want to check if there are no records in your Data Table, I think the IsBlank() function could achieve your needs. Please consider take a try with the following formula (set the Text property of a Label to following😞

If( IsBlank(DataTable1.Selected), "No records in Data Table", "Have records in Data Table" )

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No