Forum Discussion

ottiphi's avatar
ottiphi
Helper I
8 years ago

Expression.Error: We cannot convert a value of type List to type Text.

Hello all,   Please see the Scrrenshot. I have a column named "Hashtag". Each cell is automatically getting data from sharepoint. the user has in sharepoint the option to tick Checkboxes (allow mul...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

ottiphi,

Add a "Extract values" step before change type and check if you get expected result.

 #"Extracted Values" = Table.TransformColumns(#"3860ef3e-aef8-4ee7-bc63-1c29b67a7e9f", {"Hashtag", each Text.Combine(List.Transform(_, Text.From), ","), type text})


There is an example for your reference.



Regards,
Lydia

ottiphi's avatar
ottiphi
Helper I
8 years ago

Hi Lydia,

 

the code seems to work perfectly fine! Everthything just looks like it should. Thank you so much vor you held! When I apply the query changes though, I get the message as shown below ("the 'ID 2' column does not exist in the rowset"). That is true! But I just pulled the data from a SharePoint-List and did not modify the amount of columns. Also I don't have the description "ID 2" for anything in my code. Can you help me here?

 

Best regards,

Philipp

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    ottiphi,

    In your scenario, delete the extract value step from code in Advanced Editor, then check if you can apply query changes successfully.

    If there is no issue, extract values directly from UI following the guide in the screenshots below.






    Regards,
    Lydia