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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

You can try with Format(GUIDfieldhere)

Was this reply helpful? Yes No
Nilam Bhor 153 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Nilam Bhor 153 on at

Like (0)

Report

Hi ,Nitin Verma ,

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

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Nilam Bhor 153 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
HS-30042052-0 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No