Power Automate - Get Items - Filter if text Contains

Using the Get Items step on a SharePoint list in Power Automate. Here we show how you can filter on a value that "contains" another value.

Code used:
substringof('Good', Title)

Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!

We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts:

✅Express VPN - Get a 30-Day Money Back Guarantee with our link.
A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider:

✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage:

✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint:

*Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well.

Kind Regards,
The WeTechCareOfYou Team 💙

[ReinaldoGomez]

Thanks for the tip! Helped tons! Quick question, how would you do this same action for a column that isn't the Title column?

[colzz]

what if you want to check if item matches any of those words?

[ronaldokomen]

I like the video and approce you made, but the word substringof is not a part of the expression that I can use, substring I can use but than it want a integer value. the fields of the sharepoint-list are single line of text, and I want to look in witch row the word 'BP' is present.
I use a get items conector and my return-message is : Unable to process template language expressions in action inputs at line '0' and column '0': 'The template function 'substringof' is not defined or not valid.'.