web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Remove words in Excel ...
Power Automate
Unanswered

Remove words in Excel row using an Array object

(0) ShareShare
ReportReport
Posted on by 82

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

 

 

Categories:
I have the same question (0)
  • sumurthy Profile Picture
    Microsoft Employee on at

    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?

  • dwalker97 Profile Picture
    82 on at

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

     

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard