Microsoft Dynamics 365 | Integration, Dataverse...

Read Excel attachment and create records from plugin

(0) Share

Report

Posted on by dkrishna

475

Hello,

I want to read excel attachment file from email record from plugin with out using IL Merge as it is going to deprecated. Please suggest best way to read excel attachment and create records in plugin.

All responses (3)

Answers (0)

Suggested answer

Bipin D365 28,959 Super User 2024 Season 1 on at

Like (0)

Report

RE: Read Excel attachment and create records from plugin

Hi,

I don't think it will be possible to read excel attachment without using any third part DLL which requires ILMERGE.

Yes, you can register step and invoke Azure function using Plugin registration tool to read excel attachment and create record in Dynamics from azure function.

You can register you webhook to invoke azure function on Email Post Create operaton.

https://stackoverflow.com/questions/15793442/how-to-read-data-from-excel-file-using-c-sharp

xrmdynamicscrm.wordpress.com/.../

Please mark my answer verified if i were helpful
dkrishna 475 on at

Like (0)

Report
RE: Read Excel attachment and create records from plugin

You mean on create of attachment record plugin call azure function and process it?
Suggested answer

Pankaj Gogoi 3,177 on at

Like (0)

Report

RE: Read Excel attachment and create records from plugin

You can probably use Azure functions.Ffollowing articles for reference.

https://www.inogic.com/blog/2018/06/integrating-dynamics-365-with-azure-functions/

https://d365demystified.com/2020/03/19/call-azure-function-from-dynamics-365-crm-using-webhooks/

Best Regards

PG