Dynamics Community Forum Thread Details

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

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

Quick Links

Leaderboard