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(), '\\', ' '), ' ', '\')