cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dwalker97
Frequent Visitor

Remove words in Excel row using an Array object

Hi

 

I am currently trying to remove the words 'Limited' and 'Express' from multiple rows in an input table. 

 

I have stored the two strings in an Array. I have a condition that picks up on whether a row in my table contains either of the Array objects, but I am unsure as to what the next step is in the 'Yes' part of my condition. I would like to remove 'Limited' and/or 'Express' from each row.

 

I have messed around with Variables and Compose but haven't seemed to get anything working myself.

 

dwalker97_0-1607014769867.png

 

Any suggestions are appreciated.

 

Thanks

Daragh

 

 

2 REPLIES 2
sumurthy
Microsoft
Microsoft

Are you trying to remove words from specific columns or multiple/all columns or just filter the whole row if one or many columns have these words?

Hi, I am trying to remove words from the same column. This column is called 'Name'.

 

Thanks!

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

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

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (54,020)