Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Need an exact match on a condition that contains text

I need to update file properties whenever a filename contains "contract signed" or a case-insensitive variant thereof. 


So I did NAME contains "contract" and NAME contains "signed" (b/c people will name things all kinds of weird ways, like "Daniel ContrAct today SIGNED".


The problem I'm running into is that it's also picking up where they name it "contract unsigned", because we do also keep contracts drafts on file. 


How do I skirt the case sensitivity and also make it look only for signed, not unsigned? 

Super User
Super User



Are you using the ODATA filter or array filter?  You need to add the following:


AND Name not contains unsigned


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,593)