Skip to main content

Notifications

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

Send a binary file (e.g. Excel) from Sharepoint to BC

Posted on by 2

I am trying to upload a file in SharePoint to BC (to be saved as a blob or media).

I am using Power Automate to see when a new file is created in a SharePoint folder, then this triggers a flow to send the file to BC.

I have looked at what Yun Zhu and Josh Anglesea has done and I am able to use the new call Update an image, file or document (V3) to push a file to customers, vendors, items, etc. So, in theory you dont need to use Josh' custom API using HTTP calls. This call should replace all of that.

Problem is I would like to push it to my own custom table (that contains a blob field) for which I have written an API page but I cannot seem to get the behavior of pushing the file to the blob. Also tried using media and mediaset (like is done for item/vendor/customer picture field). Nothing. Maybe I am doing something wrong on the API pages. Not sure.

Recently I saw that someone using this update function to create a new attachment (which I have not tried).

Any help on this would be greatly appreciated.

TIA

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

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,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans