title: When a new item is added to SharePoint list, send email notification to users matching item category
body: <p>I'm trying to build a workflow in Microsoft Power Automate (Microsoft Flow), where users will get email notification when a new item is added to the SharePoint list, but only in case if item is relevant to their responsibilities area (based on one field value from the item, i.e. 'Market').</p>
  <p>I believe it should look like this:</p>
  <ol>
  <li>A new item is created in SharePoint list</li>
  <li>Get 'Market' field value from created item.</li>
  <li>VLOOKUP Market field value in connected spreadsheet, where we have a list of 'Markets' and corresponding responsible for market users, return email address.</li>
  <li>Send customized email notification to returned email.</li>
  </ol>
  <p>Whilst step 1 and 4 are clear and easy to do, I cannot find a way to do step 2 and 3 (I'm new to Microsoft 365 environment).</p>
  <p>Is it possible to do in Power Automate?</p>
  <p>Thanks!</p>