Share Point Single line of text column in Gallery - Add to ListBox problem

[Marty3012]

Hi, I have created a Gallery called 'Gallery1_1'. Items are set as follows;

Filter([@'SharePointListName'], StartsWith('ColumnA', ComboBox1.Selected.Result))

So I'm taking a value selected in 'ComboBox1' and then searching for it in the column 'ColumnA' which is in the SP List 'SharePointListName'. I have also created a ListBox and added the following to its Items;

This works since the column 'Dependencies' is of type lookup. I have tested the same code above with Columns that are of the type Person or Group, Choice etc. However, when I try to select a column of type Single line of Text I get the following;

The column 'Component Name' is the single line of text type and this only happens for this type. Would anyone know why this is? I've looked into various alternatives and I'm non the wiser. Any help appreciated.

Thanks

[RandyHayes · Accepted solution]

@Marty3012 

This is because you are providing a Text value to a property (Items) that expects a table or a record.  Text cannot be converted to a table or record...thus the error.

I hope this is helpful for you.