web

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

News and Announcements icon

Power Platform CommunityForums Power Apps IsBlank function in Da...

Power Apps

Answered

IsBlank function in DataTable Text

(0) Share

Report

Report

Posted on by zejdlik

Hi all,

I have an issue with IsBlank function. I want to display value in DataTable column depending on value in data source table Column_1. If the value in Column_1 = NULL, I want to display value from Column_2. I used this formula, but it doesn't work.

If(

IsBlank(ThisItem.Column_1);

ThisItem.Column_2;

ThisItem.Column_1

)

Does anybody have any idea how to solve it?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

SeanHenderson 1,104 on at

Like
a
(0)

Report
Copy link

Link copied!

@zejdlik
I don't believe you can currently make row-by-row changes of any kind like that in a data table at the moment. A data table is meant to be like a gallery. You can adjust the properties of columns, but not filter through the rows of those columns to evaluate a formula.

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @zejdlik ,

Currently, there is an known limits within Data Table control. If the column in your Data Table control has Blank value in your data source, you could not override the Blank value with other valid value, the Blank value would still remain Blank value:

As an alternative solution, I think the AddColumns function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Data Table as below:

RenameColumns( DropColumns( AddColumns( 'YourDataSource', "Column1_Value", If(IsBlank(Column_1), Column_2, Column1) ), "Column_1" ), "Column1_Value", "Column_1" )

then enable corresponding fields within your Data Table, the Column_1 would be populated with proper value.

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

Best regards,

Was this reply helpful? Yes No

Join the conversation