cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
silaman
Resolver I
Resolver I

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

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
 

1 ACCEPTED SOLUTION

Accepted Solutions
silaman
Resolver I
Resolver I

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

View solution in original post

1 REPLY 1
silaman
Resolver I
Resolver I

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,300)