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
Super User

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

This sounds like a Power Automate question rather than a PowerApps question. You are welcome to post it here but I suggest you post this in the Power Automate Community instead. You’ll get a quicker and better response over there

Link to Power Automate Community
https://powerusers.microsoft.com/t5/General-Power-Automate/bd-p/FlowForum

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

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

This sounds like a Power Automate question rather than a PowerApps question. You are welcome to post it here but I suggest you post this in the Power Automate Community instead. You’ll get a quicker and better response over there

Link to Power Automate Community
https://powerusers.microsoft.com/t5/General-Power-Automate/bd-p/FlowForum

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Highlighted
Super User
Super User

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

@ACPBSCi 

In Flow you use the Replace() function in PowerApps you use Substitute(). Without seeing your flow I can't comment and give you a solution but this link may help

 

https://faustocapellan.com/2018/05/01/express-yourself-string-functions-in-microsoft-flow/

 

Note that Flow uses single quotes in their functions whereas PowerApps uses double quotes, which can trip you up when starting out in Flow.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,814)