Data Table field properties - Text is unavailable

Like (0) Share

Report

Posted on 8 Aug 2022 01:20:00 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.

All responses (4)

Answers (0)

JBKerr 4 on 08 Aug 2022 at 04:43:24

Like (0)

Report

Re: Data Table field properties - Text is unavailable

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.)
WarrenBelz 149,158 Most Valuable Professional on 08 Aug 2022 at 02:05:37

Like (0)

Report

Re: Data Table field properties - Text is unavailable

Seems to have posted twice - see below
WarrenBelz 149,158 Most Valuable Professional on 08 Aug 2022 at 02:05:29

Like (0)

Report
Re: Data Table field properties - Text is unavailable

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
Drrickryp Super User 2024 Season 1 on 08 Aug 2022 at 02:00:31

Like (1)

Report

Re: Data Table field properties - Text is unavailable

@JBKerr

Datatable items property:

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