News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Display the Name of Cr...

Microsoft Dynamics CRM (Archived)

Display the Name of Created By of Case Record in SQL Table

(0) Share

Report

Report

Posted on by Shakti Singh Rajput

940

Hi experts,

Using logic apps insert a row in a table when a record is created in which I display the Created By, Case Name and Status of that case.

But, In Created By Field it returns the id of that user.

How could i display the name of Created By?

0451.SQL1.png

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: Display the Name of Created By of Case Record in SQL Table

Hi,

Can you share your sql query please. And also verift the tag of your question CRM Online. Is it really CRM Online as with Online you don't get access to database. Or is ti your own db.
Flydancer 1,332 on at

Like (1)

Report

RE: Display the Name of Created By of Case Record in SQL Table

Try createdbyname if you're accessing the data through a filtered view.

You can access all lookup field names with the syntax [lookupfield]name

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,409 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans