475
Hello,
I want create records in multiple entities by reading through excel sheet . Can we achieve this by creating custom work flow and action . Please suggest how to read excel data to action and custom workflow.
Thanks,
Krishna Prasad.
*This post is locked for comments
I was able to create contact records from Excel but when trying to link account record to contact record getting error .To update contact iam mapping company name with account id primary key but this is causing problem as company name is lookup field .please suggest how to map company name lookup field in update record action.
plugin or custom workflow, you need server side development to customize the data import (read all data of excel file).
Check the links please:
Create Dynamics 365 Records from an Excel using Microsoft Flow
Excel file using OpenXML in Dynamics 365 Plugin (how to create excel file via plugin in D365, you can customize)
exactly, you need to develop your plugin.
In Excel there will be entity name and specific columns will be mentioned based on that i need to records in multiple entities and need to handle some custom logic while creating records . For this i need to add button on form and show dialog window to select file .For this we achive by attach excel file to some entity and trigger custom workflow amd read data in customflow of that attachment?
Hi Krishna Prasad,
Do you want to read data from excel file and import on regular basis ? If that is the case you can create SSIS package or else use plugin.
If it's one time approach then create console application, read file and create record using Iorganization service.
you must develop your plugin.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (