DataTable

[Vstar19]

Hi. 

I have a data table reading from SharePoint. 

The Data Table is displayed as 

Name | Description | Owner 

The Owner is a People and Group Column in SharePoint. 

Many of the items in the SPO List DO NOT have an owner and by default the Data Table shows nothing. I need it to say "Unknown" if there is no owner. 

Can i do this inside of PowerApps?, 

I tried to do an if statement on the datatable. At the moment it says this ThisItem.Owner.Email 

I tried to do this, but i couldnt get it to work If(Blank(Owner_Column2), "Unknown", ThisItem.Owner.Email.  - but the formulae does not work. 

Any ideas?

[BCLS776]

You can get statements like that to work as long as you first Unlock the data table column under its advanced settings tab. Without that change, it won't recognize that you have altered the Text property for the column.

Hope that helps,

Bryan

[BCLS776]

Oh, and your condition should probably use IsBlank(), and not the Blank() function.

[v-qiaqi-msft · Accepted solution]

Hi @Vstar19,

Do you want to make the Owner column display "Unknown" if there is no value?

Could you please share a bit more about the scenario?

I think you could use the AddColumns() to achieve this.

Set the Items property of the DataTable as below:

AddColumns(
    Product,// Here replace your real data source name
    "RealEmp",
    If(
        IsBlank(Employee.DisplayName),
        "Unknown",
        Employee.DisplayName
    )
)

Please remember to add the field that you use AddColumns() to add to the DataTable.

[Vstar19]

Wow Thank You. I didnt even know the Add Columns existed. Thank you Very much. That worked a treat 🙂