Power Platform Community Forum Thread Details

Is there a way to import a list with each file attached?

I have to migrate a list from a Quickbase application to Microsoft Dataverse.

The table has more than 5000 items and each item in the list has at least 4 attachments. Is there any way to import the entire table with its attachments and relatable ID #. Or how is it possible to perform this action?

Thanks in advance !

Categories:

Microsoft Dataverse with Power Apps

Duplicate post of: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Mass-import-of-file-attachments-into-a-Dataverse-table/m-p/902542#M10917

Referencing my post:

Not sure if you resolved this already, but if QuickBase isn't getting decommissioned, you can reference its data and files via virtual tables by connecting to it's API/SQL Server. Or you can use Power Automate flow with SQL Server connector to import the data and attachments if the attachment files are stored in SQL Server. How are you planning on saving the attachments in Dataverse, Notes, File type column? Blob?

BTW, typically Dataverse is not meant to be a file repository so if you plan to import lots of attachments it may not be the best place for the licensing/storage cost and capabilities (e.g. metadata). Might be worth to have a look at Blob Storage and integrating Blob with Dataverse: https://powerapps.microsoft.com/blog/upload-files-from-powerapps-using-the-azure-blob-storage-connec...

Hope this makes sense!