How to Determine if a Contact Is an Experience Cloud (Portal) User

Query 1: Check a Single Contact

Use the following SOQL query in the Developer Console to check whether a specific Contact is associated with a Customer Portal User profile. Replace 003xxxxxxxxxxxxxxx with the actual Contact ID you want to check.

SELECT Id, Name, Email
FROM User
WHERE Profile.Name = 'Customer Portal User'
AND ContactId = '003xxxxxxxxxxxxxxx'

If the query returns a result, the Contact has an active portal/Experience Cloud user account. If no results are returned, the Contact is not a portal user.

Query 2: Check Multiple Contacts

To check whether multiple Contacts are portal users, use the following Apex snippet in the Developer Console's Execute Anonymous window:

List<Contact> lContacts = [SELECT Id FROM Contact];
List<User> lUsers = [SELECT Id, Contact.Id, Name, Email
                     FROM User
                     WHERE Profile.Name = 'Customer Portal User'
                     AND ContactId IN :lContacts];

NOTE: The first SOQL query on Contact must be scoped (filtered) to avoid hitting Apex Governor Limits. Without a WHERE clause, this query will return all Contact records and may exceed the 50,000-row Apex Governor limits. Always filter by a specific set of Contact IDs or a field condition.