web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Use IsEmpty with Data ...

Power Apps

Answered

Use IsEmpty with Data Table

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am using a data table with search fields to select a record to view or update. I want a certain group of controls to be visible if there is a selection in the data table. I use the formula:

"If(!IsEmpty(DataTable.Selected),Set(varVisible,true),Set(varVisible,false)"

This is throwing all kinds of errors.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@kaykayme You can simplify the formula like this and see if the errors are gone,

Set(varVisible, IsBlank(DataTable.Selected))

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
The IsEmpty function checks whether a table is empty (i.e., does not have any records). DataTable.Selected returns a record. If you want to check whether nothing is selected, you can use the IsBlank function:

Set(varVisible, Not IsBlank(DataTable.Selected))

Hope this helps!

Was this reply helpful? Yes No

Join the conversation