Adding bulk files to Dataverse

(1) Share

Report

Posted on by CU17011847-0

Hi Everyone,

Maybe I have fried my brain on caffeine. Here is my problem:

I want to open a dialog box to search files on a local drive.

Using the dialog box I want to select a single file or multiple files of different types (doc, pdf, xls, jpeg, etc)

I want to save the files in a dataverse table called "Jasonfiles"

In Jasonfiles there is a field called 'Document1' field type "File"

Me being the lazy programmer I am, I thought I would save a pile of time using the "Add Photo" control since it appeared to have everything I needed built in.

BUT...

If I add a "Add Photo" control called "AddMediaButton1" and use this control to select a file it appears all the file data is contained in the property "Media"

AND...

AddMediaButton1.Media is of type 'Text'

So does anyone know a easy way to convert AddMediaButton1.Media into a 'File" type to save into Document1?

Or for that matter does anyone have an easier solution to what I am trying to do?

Thanks

Jason

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

vipuljain03 673 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
The "Add Media" control (in your case, its "AddMediaButton1") is primarily designed for images, and while it stores the media as base64-encoded text in the "Media" property, it can't be used directly to upload files into a Dataverse table.

You can leverage Power Automate flow to upload files using base64-encoded data from Power Apps.

For File Picker, you can use a third-party PCF control for multi-file upload.

Below is a sample Power Apps code, which you can reuse:

Set( fileContentBase64, JSON(AddMediaButton1.Media, JSONFormat.IncludeBinaryData) ); Set( fileName, AddMediaButton1.FileName ); Set( fileType, AddMediaButton1.FileType ); // Trigger Power Automate Set( response, PowerAutomateFlow.Run(fileContentBase64, fileName, fileType) );

In Power Automate, you can use Dataverse connector to upload the file content into the "Jasonfiles" table.

----------------------------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,
Vipul

Was this reply helpful? Yes No
Suggested answer

vipuljain03 673 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Was this reply helpful? Yes No