Answered

Output to sharepoint list - how to get rid of brackets in power automate

(0) Share

Report

Posted on by KH-21042011-0

I have two flows pulling data from two separate forms but for the most part they are the same.

I had the issue of one Sharepoint field importing dynamic content that added unwanted brackets: ["Standard Delayed Employee"]. I googled and found a fix for this, added a Compose step with this expression:

replace(replace(replace(body('Get_response_details')?['rfd8f4ec3be654d65a1d1a310b15fd1e9'],']',''),'[',''),'"','')

This worked and removed the unwanted brackets.

Then I duplicated the process exactly for form #2 and I get this error message:

Unable to process template language expressions in action 'Compose_Delayed_Eval_ID' 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 'Null'. Please see https://aka.ms/logicexpressions#replace for usage details.'.

There is literally nothing different between the two flows. The question on both forms is the same, multiple choice/multiple options.

This is the flow that works:

This is the flow that returns the error message:

I'm stumped, please help?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report

Hi @KH-21042011-0,

If you copied the exact same expression from form 1 to form 2, the error is in the body('Get_response_details')?['rfd8f4ec3be654d65a1d1a310b15fd1e9']. This random value between the square brackets is a unique ID for the Form 1 question, which will necessarily be different in Form 2 (even if you have an identical question there).

Solution: remove the whole body('Get_response_details')?['rfd8f4ec3be654d65a1d1a310b15fd1e9'] from your expression and add the respective dynamic content of the Form 2 qeustion instead. I believe you already know how to do it, but you can find your Form 2 question by clicking in dynamic content tab (in yellow).

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
KH-21042011-0 94 on at

Like (0)

Report

Thank you @rzaneti, I have indeed changed the question ID for each flow and verified accuracy of that question ID. I attached screenshots in my original post with that question ID for each. When I use the output for the dynamic content it returns the response in brackets around the text, which is what I'm trying to remove by adding the compose step. Ex: ["Standard Delayed Employee"] to Standard Delayed Employee

If you have further ideas for troubleshooting I would be grateful.

Was this reply helpful? Yes No
KH-21042011-0 94 on at

Like (0)

Report

@rzaneti I re-read your post carefully and I understand your solution now, I updated my flow using the dynamic content as part of the expression and it worked! Thank you so much!

Was this reply helpful? Yes No
Chriddle 8,441 Super User 2025 Season 2 on at

Like (0)

Report

These "unwanted parentheses" indicate that this is a JSON array.
You should check the join() function instead of doing this crazy replace thing. ;)

Was this reply helpful? Yes No