Power Platform Community Forum Thread Details

How do I get the files from a SharePoint library into a file column on a Dataverse table using dataflow?

Thanks in advance

Categories:

Power Query in Dataflows cannot load a SharePoint file into a Dataverse File column.
It will show the file content as binary, but Dataverse’s File/ Image columns do not accept binary uploads through dataflows.

Option 1: Power Automate (Most Common & Easiest)
When a SharePoint file is created/modified → Add file to Dataverse file column.

Step 1 – Migration:
Use Power Automate (scheduled or manual flow) to load ALL existing files from SharePoint into Dataverse File columns.

Step 2 – Ongoing updates:
Use a trigger-based Power Automate flow to add new/updated files.

This gives you full migration + continuous sync, which dataflows alone cannot provide.

Option 2: Power Automate + Dataflow Hybrid
If you want the metadata (date created, file name, etc.) in a dataflow AND the file in Dataverse:

Dataflow loads metadata into Dataverse table (without file column).
A flow triggers when new rows are created.
Flow looks up the SharePoint file and uploads the file content into the file column.

This keeps dataflows as your ETL tool and handles binary separately.

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.