[Object][Object] Error Sharepoint Power App Table

Question

I have the following error when inserting a Table into Power App.

The reason is that Composition is a choices Column and so is effectively a table within a cell.

Looking online there do appear to be workarounds but I am struggling to get this to work for my desired table.

1. https://powerusers.microsoft.com/t5/Building-Power-Apps/object-Object-Powerapps-and-Sharepoint-list/td-p/172007 The suggestion here is to add a column which somehow for each item displays the record.

My attempt at this:

AddColumns('QSAR Analysis Submission Data'[@Composition], "newcolumn", ThisRecord.Composition)

But this just returns a similar result only specific to Composition now:

2. https://powerusers.microsoft.com/t5/Building-Power-Apps/DataTable-is-showing-object-Object-in-column-for-data-from/td-p/137040

Again this attempt fails.

ClearCollect('QSAR Analysis Submission Data', AddColumns('QSAR Analysis Submission Data'[@Composition], "newcolumn", ThisRecord.Composition))

Answer 1

If you are using single selection choice column, use:

AddColumns('QSAR Analysis Submission Data'[@Composition], "newColumn", ThisItem.Composition.Value)

For multiple selection choice column, try using formula like this:

AddColumns('QSAR Analysis Submission Data'[@Composition], "newColumn", Concat(ThisItem.Composition, Value & ", "))

Reference: SharePoint List Multi-choice column in Data table showing error