Replace function in Select doesn't work

(0) Share

Report

Posted on by sc0rpiongirl

112

Hi Community,

I have checked similar topics but they didn't seem to echo my encounter, hence, the post.

I have a flow in which I need to set up track changes in SP Lists, The flow ran successfully but the output was empty, after troubleshooting, I realized a key piece was not working as expected -

In my Get Previous Values action, I have a control using Select to retrieve the column names and the modification status (true/false), in which output I need to take out the status as "Value", and the Column Name part as "Property". As seen in the screenshot, the Column Name has \" wrapped around it. I need to get rid of them in the output. The expression I have for the Property is @replace(split(item(),':')[0],'\"','') in which I want to replace \" with nothing.

"type": "Select",
 "inputs": {
 "from": "@split(replace(replace(string(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged']),'{',''),'}',''),',')",
 "select": {
 "Value": "@split(item(), ':')[1]",
 "Property": "@replace(split(item(),':')[0],'\"','')"

But after the flow successfully ran, the output shows apparently \" was NOT replaced as expected. (See screenshot).

What went wrong? Could anyone point me a direction to a fix? Many thanks!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Have a look at this: https://powerusers.microsoft.com/t5/Building-Flows/Convert-JSON-array-to-string-array/td-p/395040

Was this reply helpful? Yes No
sc0rpiongirl 112 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply. I took a look but I don't think this is the same issue I have. As you could see I am attempting to dissect the column name dynamically, the post you referred to was using dynamic content which points to select only one column but in my case I need to take all the column names, of which picking from the available dynamic content wouldn't work.

Was this reply helpful? Yes No
sc0rpiongirl 112 on at

Like (0)

Report
Copy link

Link copied!

I am attaching two more screenshot to hopefully illustrate better about this - first is more view of the output data, these are internal column names of the SP List as noted earlier, the \" should be replaced hence removed. This will be used to intersect with another data variable (seen in the 2nd screenshot" which you can see there is no \" wrapped about the column names.

Was this reply helpful? Yes No
sc0rpiongirl 112 on at

Like (0)

Report
Copy link

Link copied!

@RezaDorrani Hi Reza, I learned to create this flow via your YT video https://www.youtube.com/watch?v=Ek4oYWPWfT0 which was awesome and very educational as your videos always are. The flow ran successfully without any error but as you could see from my previous posts, there is one hiccup which prevent the proper result being produced. I wonder if you could point me to a direction...I literally cloned your flow and it should work logically...Many thanks!

Was this reply helpful? Yes No
rbn_neu 46 on at

Like (0)

Report
Copy link

Link copied!

hi @sc0rpiongirl

Did you find any solution for this, I'm in the exact same situation where I want to replace \" with ".

Thanks

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Hi @rbn_neu,

share your flow. Do you see any error message?

Was this reply helpful? Yes No