cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

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

use the following expression

 

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

View solution in original post

6 REPLIES 6
Highlighted
Super User II
Super User II

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

use the following expression

 

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

View solution in original post

Highlighted
Helper II
Helper II

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

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.

Highlighted
Super User II
Super User II

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

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.

Helper II
Helper II

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

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.

Highlighted
Super User II
Super User II

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

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

Highlighted
Helper II
Helper II

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

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

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (5,712)