Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Identifying which email address was used to create a Case.

(0) ShareShare
ReportReport
Posted on by 474

Hi,

A large number of our Contacts have 2 email addresses connected to them, at this point in time, they can use either address to create a Case.

Is there any way of using Advanced Find to identify the number of cases that were created by Email Address 1 and/or Email Address 2? Or would you recommend a different way of finding them?

Thanks as always.

Ted

  • Suggested answer
    Paul_Owen Profile Picture
    2,027 on at
    RE: Identifying which email address was used to create a Case.

    Are you using Automatic Record Creation rules or similar to automatically create cases? If so you can capture the email address in a seperate field on the case form.

    Regards

    Paul

  • Jupiter Alappat Profile Picture
    235 on at
    RE: Identifying which email address was used to create a Case.

    You may probably create a view and add the Email related fields from Contact Entity and Created / Modified related fields from Case entity then Export to Excel to validate the data using Excel functions. If this is an On prem org - would have been more easier to run SQL query to get the desired outcome.

    Let us know what are the ways you already tried and which gave us the nearest solution to address the problem.

    Regards,

    Jupiter Alappat

  • Lennon Soeiro Profile Picture
    on at
    RE: Identifying which email address was used to create a Case.

    I tried to use the "Created By" in the Advanced Find,  but I think that it is not enough to your scenario.

    Are you using Online or OnPremise version ?

    Regards

    Lennon Soeiro

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans