Small and medium business | Business Central, N...

How to Convert GUID data type to Text in business central

(1) Share

Report

Posted on by Nilam Bhor

153

Hi Guys,

How to Convert GUID data type to Text in business central?

Is any way to do this? Please provide the sample example.

Categories:

Dynamics 365 Business Central

All responses (8)

Answers (0)

Sort by

Suggested answer

KasparsSemjonovs 4,851 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

No, GUID doesn't convert to text as it is just a string on letters and numbers in specific format.
You can search by GUID for a specific record and then get the name of it - if that is something You were trying
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can try with Format(GUIDfieldhere)
Nilam Bhor 153 on at

Like (0)

Report
Copy link

Link copied!

actually, I have created one excel report using excel buffer.

I want to display System created by field on my report. so how to display only name on my report? because its data type is GUID.

Like below is the output of my excel sheet.
Nilam Bhor 153 on at

Like (0)

Report
Copy link

Link copied!

Hi ,Nitin Verma ,

I have already tried format method, but it not gets the correct result.
Suggested answer

KasparsSemjonovs 4,851 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Copy this GUID, and use this value to search table User (2000000120) by the field User Security ID (field ID 1).
Then from the record You find, take the User Name (Field ID 2) and add this value to the Excel.

Quite simple. And this was already suggested in other topic before You created this.
Suggested answer

YUN ZHU 103,644 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, If you mean User Security Id (SID) and User Id (Name), hope the following helps.

User Security Id (SID) and User Id (Name): https://yzhums.com/25881/

Thanks.

ZHU
Nilam Bhor 153 on at

Like (0)

Report
Copy link

Link copied!

Hi KasparsSemjonovs,

Is any way to get GUID for a specific record and then get the name of it?

Can you please provide the sample example?
HS-30042052-0 10 on at

Like (0)

Report
Copy link

Link copied!

You can convert a GUID data type to text in Business Central by using the "FORMAT" function. Here's a sample example: FORMAT(MyGUIDField, 'N0') where MyGUIDField is the name of the field containing the GUID you want to convert to text.