For example, if you type the letter J, Outlook will return results that contain John, James, Jack, Julian, and Julie. If you type Jul, Outlook will return results that include Julian and Julie in any field, including company name, email address, and physical address.
Tips: If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF (B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function.
For example, "name": John, or "state": WA are objects. The easiest way to use column formatting is to start from an example and edit it to apply to your specific field. The link column formatting JSON reference contains examples that you can copy, paste, and edit for your scenarios.
Example: John Doe is at work and sends himself an email from his work inbox to his own inbox, johndoe@microsoft.com, Note to Self appears as the sender. However, if John sends it to his alternate personal email address johndoe@outlook.com, the email will still appear in the inbox, but the display name will show as John Doe.
For instance, the same query "emails from John about planning" will now fetch any email containing the words 'John' and 'planning,' regardless of their context – like searching with “John planning." To ease the transition, you can use the search filters available in each Microsoft 365 app, which offer robust methods to refine search results.