Power query - Go trough list and add text with each step (for each statement)

[Anonymous]

Hi everyone

I have a list for example:

• A
• B
• C
• D

Now I want to create a query in power query that will create a text like this:

"The letters are: "  A B C D

I already have this query:

let
    xx=   KEYListfunction(),
    list = Text.Split(xx, ","),
    text = "",
   loop = List.Accumulate(list, 0, (state, current) => text = text &  " " & current ))
in
loop

But the result only says "FALSE"

[v-lili6-msft · Accepted solution]

hi @Anonymous 

You may useText.Combine instead of List.Accumulate Function

https://docs.microsoft.com/en-us/powerquery-m/text-combine

Regards,

Lin

[Anonymous]

Great thank you very much!