Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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

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.




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?).


Accepted Solutions
Resident Rockstar
Resident Rockstar

use the following expression



View solution in original post

Resident Rockstar
Resident Rockstar

use the following expression



View solution in original post

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.

Resident Rockstar
Resident Rockstar

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.

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.

Resident Rockstar
Resident Rockstar

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

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

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,992)