web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add text at beginign o...
Power Automate
Answered

Add text at beginign of string

(0) ShareShare
ReportReport
Posted on by 2

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

IvoFe_0-1717815457192.png

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:

IvoFe_1-1717815496041.png

 

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:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    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! 🙌

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    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! 🙌

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard