I've got a SharePoint list. Every custom column is a text column. OnStart of the app I filter and ClearCollect the data source into a collection. I then display this collection in a gallery. The first 9 items display perfectly, however the 10th item and beyond shows "[object Object]" for the text field. The label is set to ThisItem.ColumnName. I have verified the column in SharePoint is of type Single Line of Text. To troubleshoot, I inserted a data table and set the items to the same collection. The column displays perfectly (see screenshot).
How can I get the column to display correctly? I can change it to a LookUp back to the datasource, but it increases the load time. Any help is appreciated!
Solved! Go to Solution.
Hi @CapstoneAdmin ,
ClearCollect(collectiontest,Filter(SpList,<condition>))
Is there any difference between the first 9 items and the 10th items(firstly compare the information in “ColumnName”)? Such as, is there any characters in the 10th items? [object object] would typically indicate that the data you are trying to display is complex rather than a simple text field. Not sure which format of data are kept in your ColumnName column. As a result, try to set your label to below formula then check if issue still exists:
PlainText(ThisItem.ColumnName)
If PlainText() still do not work, you may try below method:
ClearCollect(collectiontest,AddColumns(Filter(SpList,<condition>)," NewtestColumn ",ColumnName))
ThisItems.NewtestColumn
Best Regards,
Allen
Hi @CapstoneAdmin ,
ClearCollect(collectiontest,Filter(SpList,<condition>))
Is there any difference between the first 9 items and the 10th items(firstly compare the information in “ColumnName”)? Such as, is there any characters in the 10th items? [object object] would typically indicate that the data you are trying to display is complex rather than a simple text field. Not sure which format of data are kept in your ColumnName column. As a result, try to set your label to below formula then check if issue still exists:
PlainText(ThisItem.ColumnName)
If PlainText() still do not work, you may try below method:
ClearCollect(collectiontest,AddColumns(Filter(SpList,<condition>)," NewtestColumn ",ColumnName))
ThisItems.NewtestColumn
Best Regards,
Allen
Hi @CapstoneAdmin ,
How are things going? Have you solved your issue?
If my solution is helpful to you, please mark my answer. This will benefit other community members who stuck with the same question.
Best regards,
Allen
User | Count |
---|---|
239 | |
116 | |
94 | |
58 | |
32 |
User | Count |
---|---|
287 | |
132 | |
106 | |
63 | |
57 |