cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ACPBSCi
Resolver I
Resolver I

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
Gristy
Resident Rockstar
Resident Rockstar

use the following expression

 

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

View solution in original post

6 REPLIES 6
Gristy
Resident Rockstar
Resident Rockstar

use the following expression

 

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

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

Gristy
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

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,213)