Hi Venkata, Based on your provided description, I assume that you wanted to find such SharePoint “Document location” records in CRM for which the account table record status is inactive . Currently, there is no direct way to achieve the same. As a workaround, we can use advanced find with some conditions as shown below to find the same: Hope this helps. Thanks!