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

Extract images from excel to list page in business central

(1) Share

Report

Posted on by RK-29050523-0

157

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,448 Super User 2025 Season 2 on at

Like (2)

Report

Hopw it provide some hit: https://www.dynamicsuser.net/t/import-export-item-picture-from-to-excel-business-central-oncloud-extension/66579

https://yzhums.com/39849/

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

Was this reply helpful? Yes No
YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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

https://yzhums.com/40077/

Thanks

ZHU

Was this reply helpful? Yes No
RK-29050523-0 157 on at

Like (0)

Report

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 ??

Was this reply helpful? Yes No
Suggested answer

Kamalkhakhkhar8 58 on at

Like (2)

Report

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.

Microsoft Dynamics 365 Business Central: How to use Excel Buffer to Import data | Dynamics 365 Lab

Dynamics 365 Business Central: How to convert Image (item picture) to encoded text (Base64 String) via AL | Dynamics 365 Lab

Dynamics 365 Business Central: How to convert Image (item picture) to encoded text (Base64 String) via AL | Dynamics 365 Lab

through this 3 blog you can able to get the image from excel to Business central.

Thank You.

Kamal Khakhkhar.

Was this reply helpful? Yes No