Take Value from Column A, Clean it Up, Populate Column B

[ACPBSCi]

I have a flow that populates a text column with the folder path. I want to take the folder path, replace the slash with a comma and a space, and populate the Keywords site column.

From:

library/folder/subfolder/sub-subfolder

To:

library, folder, subfolder, sub-subfolder

I'm new to flow, but a solid Nintex user. I know it can be done and rather simply, but I'm not sure how. I guess you could say I'm learning flow by immersion (see what I did there?).

[Gristy · Accepted solution]

use the following expression

replace('yourvalue','/',',')

[ACPBSCi]

Hi, Gristy. Thank you for replying!

Do I do this with Initialize Variable? Set Variable? I see a Regular Expression is something that is technically "available", but my company blocked my ability to go get it. It also looks like my text column that I created for the folder path is not available in dynamic content.

I'm stumped.

[Gristy]

when inserting dynamic content, there is a expression tab in the same place.

dynamic content is sometimes buggy you may need to reload your flow.

[ACPBSCi]

Okay, I think I'm getting closer. My flow works beautifully when I add content to the library (and don't ask me how, I have 2 separate flows and one is dependent on the other one finishing first - so far no errors). This is exactly what I want it to do for new content. However, I need to update existing content. I'm guessing my trigger needs to be different.

How do I create a flow that:

1. Can be manually triggered
2. Will query all existing items in the library
3. Go through each library item and
   1. update the file path (already built)
   2. clean up the value of the file path and populate the keywords column (already built)

Like I said, I'm new to Flow. I have built this sort of functionality in Nintex, but I'm just not sure of some of the controls and actions in Flow.

[Gristy]

search triggers for button and use a Get Items to get all the items in the list 🙂

[ACPBSCi]

I have more questions that I am going to move to a new post.