0

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

enter image description here

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

enter image description here

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

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.. [enter image description here

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

AGain this attempt fails.

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

Hoping someone more familiar with powerapps code can help.

4
  • If "Composition" is a single selection choice column in SharePoint, try using this: AddColumns('QSAR Analysis Submission Data'[@Composition], "newColumn", ThisRecord.Composition.Value). Use newColumn to show in the table. Let me know if it works for you. Commented Feb 28 at 13:08
  • Hi there, thanks for the response. Unfortunately, the code provides the same as in the final image. I have also added another image to Show the Composition choices. Note it is possible to have multiple choices selected too within a cell.
    – Nick
    Commented Feb 28 at 13:15
  • 'Concat(ThisItem.Composition, Value & ", ")' Appears to be the solution
    – Nick
    Commented Feb 28 at 13:31
  • Use concat() function for multiple selections Commented Feb 28 at 13:31

1 Answer 1

1

For multiple selection choice columns, 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.