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 / Additional / backslash...
Power Automate
Unanswered

Additional / backslashes is getting added for specific column

(0) ShareShare
ReportReport
Posted on by
Hi Experts,
I am currently working on exporting data from a paginated report that includes multiple value parameters. Since we cannot pass these parameters manually, I am using a SharePoint list to retrieve the parameter values.
 
We have a column that contains user information in the format Domain\Username. However, when reading this column from the SharePoint list, it adds extra backslashes, resulting in an output like Domain\\Username.
 
I attempted to use the replace function in a select operation, but it is not working as expected. Could you please assist?
 
Here are the expressions I tried:
 
replace(item(), '\\', ' ')

replace(replace(item(), '\\', ' '), ' ', '\')
 
 
 
Input : eg: Createdby_Column
 
 
Flow:

 
 
 
Expressions used in the select operation for value:
replace(replace(item(),'\\',' '),' ','\')
 
 
Output of Get item & Apply to each loop:
 
 
 
 
 
 
Categories:
I have the same question (0)
  • Manish Solanki Profile Picture
    15,169 Moderator on at
    Hi,
     
    This is because array variable escape single \ by replacing with \\ but when you retrieve a value from array, it will give you the correct value.
     
    Here is an example:
     
    I have extracted the first element of an array using expression in compose action: first(variables('varArray'))
     
     
    Output of compose action on flow run:
     
     
     

    If this helps & solves your problem, please remember to like and accept my solution as it will help others in the future.

    Thanks,
    Manish Solanki
    Manish Solanki | LinkedIn
    Blog: https://manish-solanki.com/
    YouTube Channel: Manish Solanki - YouTube

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 482

#2
11manish Profile Picture

11manish 280

#3
David_MA Profile Picture

David_MA 268 Super User 2026 Season 1

Last 30 days Overall leaderboard