Power Platform Community Forum Thread Details

Power Pages - Upload photo directly to Dataverse table - Not to Azure Blob or Notes

Dear Community,

I want a simple solution to upload photos directly to my Dataverse table, which is what my website is built on.

The answer is usually no. The upload, or how the attachment works in the Power Pages, is usually via Azure Blog or Notes.

It is just the way D365 has always been working this way.

When you insert your form to the page, you can enable the attachment.

And then you can see the upload option in your form.

I created a label called "Upload to D365", just to highlight by click the "Choose File" button, it will upload to D365. Most people will configure it as Notes. PS I also don't know my photo column is outside the frame.

I understand this and I know it is not possible to upload directly to my Dataverse table, until I tried the following.

In my table, there is already an image column.

When I inserted the new form to the page based on this table, the photo field get populated with the correct input control, which is expected.

Then I moved on to create my list page to display the table data, enabled view and edit for the record.

To my surprise, when I clicked on the View details, the photo field has actually displayed the image data that was stored in the table.

More surprisingly, if I select the Edit, I can delete the photo, and upload new photo.

I tried it and it writes straight back to the dataverse table and works smoothly.

As you can see, the input control here is responding to the Photo column in the table, not the Form attachment, which would have a different text label.

So that tells me, it is possible that in the Power Pages, you can have an input control that directly upload the data back to the Dataverse table.

When I tested the site on a tablet, it can also use the device camera to take photo and submit to the Dataverse.

So my question is, why in my New Form page, I couldn't have this input control working. It does not trigger an input control.

This error is almost like the Photo field is in the wrong mode.

All three forms are exactly the same but in different mode, Insert/ReadOnly/Edit.

The new form is in the Insert mode, but this Photo field, seems like trying to display the data, which of course has nothing to show.

Thank you very much!

Categories:

General topics

Historically, Notes was the only option, however more recently Microsoft introduced a new field type for File, and so now File is also available. However, File type columns are only available after the base record has been created/saved. You will see the same message if you have a File field in a Model Driven app.

Behind the scenes (Portal Management /Power Pages App) there is a checkbox on the portal form's definition for Notes and only if that checkbox is ticked will it allow Notes to be attached as part of the creation of the record, if that checkbox is not checked and you just configure a metadata record for the portal form Notes also can only be attached after the main record is created.

As to why, I would guess that it has to do with the fact that the file data is actually stored in a different Table - even though you see it as a field on the main table, the data is actually stored in a different table. To link the file data to the main record the main record needs to exist (as creation will generate its internal GUID).

For Notes, the portal has the special checkbox which changes the order the records are created in and then it performs updates behind the scenes (in the portal code), Microsoft have not implemented the same for File type columns (and it technically may not be possible at the moment as they are structured differently to Notes - You could always create a Note without its Regarding field being populated and update it later [the Regarding objectid is the link to the main record], but the File column is tightly bound to the main Table)

Quick Links

Subscribe to this forum!