We have a scenario where a department are maintaining new vendor - item data in D365. The information that is to be updated in D365 is divided into multiple entities for import: trade agreement journal lines, Approved vendors, default order setting, external item description
Question is if there are any tools to use for a business user (not having access to "data management" module) so that they can upload the 4 entities needed for data update in relation to new product - vendor introduction.
The "office integration" based on Odata per entity is not an option as this would be too cumbersome timewise.
Any ideas for e.g. power automate to pick up 4 excel documents with the data on demand from the business user and import ?
Thanks in advance for any thoughts