2 versions · feature-files-and-images.md
v26 days agomarkdown import
… 10 unchanged lines …- Images can't be enabled for search or sorting. Files can't be sorted.- Both can be secured with column-level security, but neither can be masked.- In model-driven apps, uploading or deleting a file happens immediately rather than on form save. Discarding changes doesn't bring a deleted file back.+ - Developer behaviour, per the [image column data article](https://learn.microsoft.com/en-us/power-apps/developer/data-platform/image-column-data): image data can be set with an update and deleted by updating the column to null, whereas files are uploaded and deleted individually. A retrieve returns the thumbnail, and each image column has a companion string column holding a relative download URL.+ - Full-size storage is controlled by the column metadata property CanStoreFullImage. Check it per column through RetrieveMetadataChanges rather than assuming; the metadata query cannot filter on it directly.- For capacity, any custom or standard table with a file or image (full size) column counts against **file** storage, alongside Attachment, AnnotationBase and web resources.## When to use / skip… 10 unchanged lines …- The image thumbnail is the one that generates complaints. Users upload a photo of a damaged part, it comes back as a cropped 144 pixel square, and they conclude the system is broken. Use a file column for anything that needs to be viewed properly.- File maximum size being immutable means an under-sized column has to be replaced, and replacing it means migrating the binaries.- File deletes on a form are immediate. There is no undo, and "I clicked cancel" doesn't help.+ - Unsupported file types and oversized uploads both fail with the same generic ProcessImageFailure error (code 0x80072553), so the message alone won't tell you which it was. Check the type and MaxSizeInKb.- File storage is a separate capacity bucket from database. Excess file capacity can't cover a database or log deficit, and excess database capacity can't cover a file deficit either. Watching one number tells you nothing about the other.- No required-field validation on file columns, so "the user must attach the document" needs enforcing somewhere else entirely.
v13 months agomarkdown import
Initial version.