Answered

Add text at beginign of string

(0) Share

Report

Posted on by IvoFe

Hello, I'm ediiting a flow in which i have a select:

chunk(body('Select_2'),length(body('Select_Headers')))

json(concat('{"__metadata":{"type":"SP.Data.', replace(outputs('settings')['listName'], ' ', '_x0020'), 'ListItem"},' , replace( replace( join(item(),',') , '{' , '') , '}' ,'') ,'}' ))

And generates me this output:

What i want to achieve is that if the column name starts with an _x00, add at the beggining an OData_, but cant figure how to do it, could someone please give me a hand?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @IvoFe

Try this updated code under Map field of select action

json(concat('{"__metadata":{"type":"SP.Data.', replace(outputs('settings')['listName'], ' ', '_x0020'), 'ListItem"},' , replace( replace( join(json(replace(string(item()),'_x00','OData_x00')),',') , '{' , '') , '}' ,'') ,'}' ))

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @IvoFe

Try this updated code under Map field of select action

json(concat('{"__metadata":{"type":"SP.Data.', replace(outputs('settings')['listName'], ' ', '_x0020'), 'ListItem"},' , replace( replace( join(json(replace(string(item()),'_x00','OData_x00')),',') , '{' , '') , '}' ,'') ,'}' ))

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No