Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to Convert GUID da...
Small and medium business | Business Central, N...
Suggested answer

How to Convert GUID data type to Text in business central

(1) ShareShare
ReportReport
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
  • HS-30042052-0 Profile Picture
    HS-30042052-0 10 on at
    How to Convert GUID data type to Text in business central
    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.
  • Nilam Bhor Profile Picture
    Nilam Bhor 153 on at
    How to Convert GUID data type to Text in business central
    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?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 78,034 Super User 2025 Season 1 on at
    How to Convert GUID data type to Text in business central
    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
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,075 Super User 2025 Season 1 on at
    How to Convert GUID data type to Text in business central
    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.
  • Nilam Bhor Profile Picture
    Nilam Bhor 153 on at
    How to Convert GUID data type to Text in business central
     
    I have already tried format method, but it not gets the correct result.
  • Nilam Bhor Profile Picture
    Nilam Bhor 153 on at
    How to Convert GUID data type to Text in business central
    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.
     
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,324 Moderator on at
    How to Convert GUID data type to Text in business central
    Hi,
    You can try with Format(GUIDfieldhere)
     
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,075 Super User 2025 Season 1 on at
    How to Convert GUID data type to Text in business central
    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February 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... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans