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

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.

Highlighted
Helper I
Helper I

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 I
Helper I

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,301)