Unanswered

Concat Output to Sharepoint list - How to get rid of square brackets

(0) Share

Report

Posted on by Community Power Pla...

Firstly thank you in advance for your help!

I've created a flow that updates a SharePoint list.

To merge the old and new values (in my case Opportunity IDs) I have used the below concat function. This seems to work fine and when tested the output displays as I would like without any brackets.

concat(outputs('ExistingSFDC'),' ', outputs('NewSFDC')) - I have called this MergedSFDC

However, when I then add the step to my flow to update my Sharepoint list (adding

outputs('MergedSFDC') to my selected column) the output shows as the following in SharePoint:

["21723748 123456"]

I tried to use the replace function to get rid of the brackets, entering it into the field (SFDC) I want to fill in Sharepoint.

replace(replace(outputs('MergedSFDC'),'[',''),']','')

but that produces the following failure:

Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Array'.

Does anyone know how to get rid of the brackets?

Many thanks 🙂

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

I have also tried the following expression:

replace(replace(string(outputs('MergedSFDC')),'[',''),']','')

but the output is still the same

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous,

Try to convert it to a string first.

Try something like below:

replace(replace(string(outputs('MergedSFDC')),'[',''),']','')

Or you could also use a slice instead:

slice(string(outputs('MergedSFDC')), 1, -1)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus ,

Thanks for your quick reply! I've just tried both of your suggested options above but still seem to be having the same problems. The output of the compose works great as can be seen below.

But when I then use outputs('SFDCOutput') to update my Sharepoint it still returns the brackets. And shows the exact the same in Sharepoint.

The sharepoint column is a text column, I have also tried switching it to a number column but it still doesn't work.

Do you have any other suggestions? Thanks!

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

That SFDC is a single line of text field, correct? Or are you using a different type of field?

Can you also share a screenshot of the rest of your flow setup? This might be useful for troubleshooting.

Was this reply helpful? Yes No