Data Table field properties - Text is unavailable

(0) Share

Report

Posted on by JBKerr

Hello, how can I restore / add / display the property Text for a field in a data table?

The only properties that display for the field in the data table are:

AutoWidth
ContentLanguage
DisplayName
IsHyperlink
OnSelect
Visible
Width

The field is a Choice field from a Sharepoint list. To get the field contents to display properly, several pages and videos I've found advise I should use the Concat function in the Text property to turn the contents into a string.

But the field doesn't have a Text property to edit... 🤷‍♂️

Is it a setting on the data table? This app was built by a colleague several years ago, so I am unfamiliar with what went into creating it and just need to add this column.

Categories:

Building Power Apps

I have the same question (2)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@JBKerr

Datatable items property:

AddColumns(table,"somename",choicefield.Value)

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JBKerr ,

I assume this is a Multi-Choice field - replace with your field name

Concat(ThisItem.YourFieldName,Value,",")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Seems to have posted twice - see below

Was this reply helpful? Yes No
JBKerr 4 on at

Like (0)

Report
Copy link

Link copied!

Many thanks @Drrickryp , that looks handy. How ought I add this to the formula currently in the property? This is what occupies the Items property field already:

Sort(Filter('TableName',TextSearch.Text in 'Field01' || TextSearch.Text in 'Field02' || TextSearch.Text in 'Field03'),'ID Number',Ascending)

I have tried adding ";;" to the end and pasting your formula. Plus I have tried to follow the syntax in this post. Both were unsuccessful: no column was added. (FYI I am trying to add a Field04, which does not need to be searched.)

Was this reply helpful? Yes No