Effortlessly clean up your data in Power Automate or Logic Apps—remove unwanted characters, symbols, or numbers from any string with a single, lightning-fast action! Learn how to streamline your workflow automation using low-code Power Platform tools and clever expressions for maximum efficiency.
In this hands-on tutorial, you'll discover a repeatable method to strip out anything you don't want from your strings—perfect for prepping filenames for SharePoint, extracting numbers from messy data, or just tidying up user inputs. No more clunky loops or extra variables—just one smart, scalable solution for digital transformation and business process automation.
What You’ll Learn:
✔️ Build a Power Automate flow that removes or keeps specific characters using just one Select action
✔️ Transform strings into arrays with the Chunk expression for granular control
✔️ Use Contains, If, and Join expressions to filter out unwanted symbols, letters, or numbers
✔️ Adapt the method to extract only numbers—ideal for citizen development and BPA scenarios
Timestamps:
00:00 – Instantly Remove Unwanted Characters from Any String in Power Automate
00:25 – Setting Up a Flow to Identify Characters to Remove
01:40 – Splitting Strings into Arrays Using Chunk
02:27 – Detecting Characters with the Contains Expression
04:23 – Filtering Out Symbols, Numbers, and Letters
05:14 – Rebuilding a Clean String with Join
06:28 – Extracting Only Numbers from Text
08:20 – Recap and Real-World Use Cases
#PowerAutomate #workflowautomation #LowCode #PowerPlatform #digitaltransformation
Ready to supercharge your Power Platform skills? Try this method in your next cloud flow and let me know how it goes in the comments! Got a tricky string-cleaning scenario? Drop your questions or video ideas below—I love helping the community solve real challenges.
🫠 About me:
👋 Hi, I'm Damien Bird — Power Platform Cloud Solution Architect at Microsoft ☁️
🧠 Former Forum Super User (2021/22) & Business Applications MVP (2022)
🎤 Speaker at conferences across Europe, the US, and local UK user groups
💡 Passionate about sharing knowledge, solving problems, and empowering the community with the Power Platform!
📚 Explore more:
🔗 Blog: https://DamoBird365.com
🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube
🎓 Join the Community: https://DamoBird365.Teachable.com/p/DamoBird365Membership
💖 Support the Channel: https://youtube.com/@DamoBird365/membership
☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365
💼 LinkedIn: https://LinkedIn.com/In/DamoBird365
🐦 Twitter: https://x.com/DamoBird365
🌐 Bluesky: https://bsky.app/profile/DamoBird365.bsky.social
📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis