Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Extract images from ex...
Small and medium business | Business Central, N...
Suggested answer

Extract images from excel to list page in business central

(1) ShareShare
ReportReport
Posted on by RK-29050523-0 13
Hi expert's 
We are working on Poc where we need to extract images from Excel by uploading it when i tried it's converting image into {0E005B77-058C-4576-8743-0789E2D37B70}
Is there any best approach to it ??



 
Categories:
Business Central
image (7).png
  • Suggested answer
    Kamalkhakhkhar8 Profile Picture
    Kamalkhakhkhar8 13 on at
    Extract images from excel to list page in business central
    hii there,
    as per your requirement you can import data using excel buffer and as per YUZ ZHU you need to go through his some of blogs and combine the requirement.
     
     
     
     
    through this 3 blog you can able to get the image from excel to Business central.
     
    Thank You.
    Kamal Khakhkhar.
  • RK-29050523-0 Profile Picture
    RK-29050523-0 13 on at
    Extract images from excel to list page in business central
    hi YUN ZHU  & khushbu here is the excel that i want to import in business central . in the excel the images are stored in place in cell 
    if they can be done using the Azure functions how can i do it ??



  • YUN ZHU Profile Picture
    YUN ZHU 73,110 Super User 2024 Season 2 on at
    Extract images from excel to list page in business central
    Do you just want to get the media type ID?
    If so, you can get it using the following method.
     
    If you want to convert to encoded text (Base64 String), I hope the following information can give you some hints.
    Dynamics 365 Business Central: How to convert Image (item picture) to encoded text (Base64 String) via AL
     
    Thanks
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 4,436 on at
    Extract images from excel to list page in business central

    Could you confirm how the images are stored in the Excel file? Are they Base64 strings, file paths, or embedded objects?

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans