Guidance question - CRUD actions for multiple file attachments

Like (0) Share

Report

Posted on 18 Jan 2023 19:00:07 by Sjostrom

I have two Dataverse tables: PrimaryTable and FilesTable (one to many, respectively). For each primary record, I may have several file related records.

Does there exist out-of-the box Power Page controls that allow a user to add/view/delete multiple files in this scenario of 2 related Dataverse tables? Thanks for any guidance, examples, demo, etc. to help me get started.

I am aware of a recent PowerUsers article (1/16/2023) on uploading/managing multiple files, via Graph API, to a SharePoint document library. Curious though, if there exists a Dataverse-only solution with out-of-the-box controls.

Thanks in advance for any guidance/direction

Categories:

WEB API

Tips & Tricks

General

All responses (1)

Answers (0)

oliver.rodrigues 9,342 Most Valuable Professional on 02 Feb 2023 at 09:17:56

Like (0)

Report

Re: Guidance question - CRUD actions for multiple file attachments

Hi, how are you uploading your documents? is it to sharepoint or to dataverse notes?

Upload

If you are using Notes, you can allow multiple file upload, which would upload multiple notes against your File Table Record

Set up notes as attachments for basic and multistep forms - Power Apps | Microsoft Learn

Manage

not sure what you mean by manage, how can a user manage multiple files at once? can you let us know your scenario?

Delete

If your files are associated with a specific "Files Table" record, the default (and unchangeable) Relationship Cascade Behavior is to to remove the notes automatically: