Forum Discussion

respinosa1962's avatar
respinosa1962
Frequent Visitor
4 years ago
Solved

Error when expanding a column: No columns were found

I have a SPO list where a column named "Business Owner" is a people picker field.  When I try to connect to it using 2.0 (Beta), I get this error:   When I connect using 1.0, the preview is t...
Need Help
  • respinosa1962's avatar
    respinosa1962
    4 years ago

    I got this tip from a colleague.  There is a field called 'FieldValuesAsText'.  Expanding that one allowed me to get the field I needed.

respinosa1962's avatar
respinosa1962
Frequent Visitor
4 years ago

I got this tip from a colleague.  There is a field called 'FieldValuesAsText'.  Expanding that one allowed me to get the field I needed.

hisham89's avatar
hisham89
New Member
1 year ago

Hi respinosa1962,

I'm having the same problem - "No cloumns were found" in expanding one of the column in the XML table.  

 

Can you explain further on how to get to "FieldValuesAsText" and expand it, it seems I couldn't find the field anywhere inside the table?  Thanks.