Forum Discussion
Cannot convert a value of type Table to type List - data export from a sharepoint
Hello,
Thank you for your response. I'm not very well read in power query so trying to understand what you mean by 'Make sure that the transformation function is correctly defined'. This code is what Power BI did automatically for me when I exported from the sharepoint table.
When I replace Table.toRows to Table.toRecords for all my transformations, I instead get this error:
What does this mean?
I've exactly the same problem and still not found a solution, do you ?
Hi Neo_Mando, I hope you found the solution to the problem.
My solution was to change UserMultiTransform script. Changes marked in bold below. I hope this helps.
UserMultiTransform = Table.AddColumn(UserMultiTypeRows, "UserMultiTransform", each(name) =>
if (name <> null) then @Text.Combine(Table.Column(Table.FromList(Table.ToRecords(name), Record.FieldValues, UserFieldNames), "title"), ", ") else null, Function.Type)
