Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
4 years ago

List to text

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.

Need Help

3 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    I'm guessing what you want is this:

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

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    mb0307 How about this?

    let
    Source = { " ""20200925"", ""20201030""" },
    Text = Lines.ToText(Source)
in
    Text
  • GateJay's avatar
    GateJay
    Frequent Visitor
    2 years ago

    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):