List to text

[mb0307]

Hi,

I have a List values:

I want to use exactly same format with "" shown above in this query:

{Cube.ApplyParameter, "[!V000004]", {{ #"ListName"}}},

If I provide the ListName then i get this error:

Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=[List]
Type=[Type]

How can i convert List values to Text and use in my query please?   

keeping the List format with "" like this:

"20200925", "20201030", "20201127", "20201225", "20210129", "20210226", "20210326", "20210430", "20210528", "20210625", "20210730", "20210827", "20210924", "20211029" 

Thanks in advance.

[GateJay]

Hi,

I was dealing with same issue and solution was to keep the list in form of list instead of string and to remove one pair of {}.

Working code:

{Cube.ApplyParameter, "[!V000004]", {List1}}

Together with list (square bracket are there because of weird naming convenction we have here):

[AlexisOlson]

I'm guessing what you want is this:

{Cube.ApplyParameter, "[!V000004]", {Text.Split(#"ListName"{0}, ",")}},

[Greg_Deckler]

@mb0307 How about this?

let
    Source = { " ""20200925"", ""20201030""" },
    Text = Lines.ToText(Source)
in
    Text