title: Power Query check if string contains strings from a list
body: <p>Is there a way to check a text field to see if it contains any of the strings from a list?</p>
  
  <p><strong>Example Strings to Check:</strong></p>
  
  <pre><code>The raisin is green
  The pear is red
  The apple is yellow
  </code></pre>
  
  <p><strong>List Example to Validate Against</strong></p>
  
  <pre><code>red
  blue
  green
  </code></pre>
  
  <p>The result would be</p>
  
  <p><strong>either:</strong></p>
  
  <pre><code>green
  red
  null
  </code></pre>
  
  <p><strong>or:</strong></p>
  
  <pre><code>TRUE
  TRUE
  FALSE
  </code></pre>