Expression.Error: We are unable to convert the value "1" to the List type.

[Junnsouzza]

Hello. I'm trying to convert a parameter's list into a text string to query the Oracle database. I'm using the Text.Combine() function but I'm not successful. I created a simple list containing 3 lines with the codes of the 3 companies in the database table, and i want to bring the data from these companies when executing the database query. The function returns the following error:

Lista = Text.Combine(Text.Combine(Par_Empresas, ", "))

[PhilipTreacy · Accepted solution]

@Junnsouzza 

Why are you using 2 nested Text.Combine functions? 

Text.Combine also requires a list as input so try 

Lista = Text.Combine({Par_Empresas}, ", ")

Regards

Phil