Answered

Concat won't , "-", (The expression is invalid.)

(0) Share

Report

Posted on by Modulas

146

I can't get power automate Concat to do the following, even though I've checked everywhere that using , " ", is ok. Its even in the MS guides

concat(triggerOutputs()?['body/Application_x0020_Code_x003a__x0/Value'], "-",triggerOutputs()?['body/ProjectPart/Value'])

Power automate won't let add it as it says its invalid.

It will happily run without the ,"-", and smash it all together but just won't allow me to separate with -

I have also tried , '-', as well

For context I am collecting 2 column list values and connecting them together via - to which I am then using it to create a folder

The folder should be something like ABC-123 but it only wants to do ABC123.

I only really got into power automate a short while ago and am a noob

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Modulas 146 on at

Like (0)

Report

I got it in the end

If I make "-" a variable I can add it like this

concat(triggerOutputs()?['body/Application_x0020_Code_x003a__x0/Value'],variables('var"-"'),triggerOutputs()?['body/ProjectPart/Value'])

I'll leave this here in case anyone else comes across this

Was this reply helpful? Yes No
fmcristaldi 2 on at

Like (0)

Report

mate, don't know if it is accurate or not but I believe that double quotes doesn't work as text delimiter.
I tried using single quotes '[text_inside]' and it worked, while using double quotes "[text_inside]" it did not.
One of many Power Automate peculiarities.

And yes, your method works as well (maybe because you create a string variable and forces Power Automate to recon the entry/prompt as text, hence concatenating properly)

Was this reply helpful? Yes No