Forum Discussion

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

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

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