IsBlank function in DataTable Text

[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.

[SeanHenderson]

@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."

[v-xida-msft · Accepted solution]

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,