Power Automate - Building Flows

Answered

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

Like (0) Share

Report

Posted on 21 Apr 2025 20:25:40 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:

Business Process Flows

All responses (4)

Answers (1)

Chriddle 7,932 Super User 2025 Season 2 on 22 Apr 2025 at 14:27:50

Like (0)

Report

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

These "unwanted parentheses" indicate that this is a JSON array.
You should check the join() function instead of doing this crazy replace thing. ;)
KH-21042011-0 61 on 22 Apr 2025 at 13:41:12

Like (0)

Report

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

@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!
KH-21042011-0 61 on 22 Apr 2025 at 13:31:41

Like (0)

Report

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

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.
Verified answer

rzaneti 4,096 Super User 2025 Season 2 on 21 Apr 2025 at 21:32:44

Like (1)

Report

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

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

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Announcing our 2025 Season 2 Super Users!

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Announcing our 2025 Season 2 Super Users!

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates