Upload multiples files to dataverse table

(1) Share

Report

Posted on by EmilioRoqueta69

565

Hi all,

Viewing these videos, I created a dataverse table for register Invoices data and another table for the Invoices Attachments:

Upload files to Dataverse from Power Apps | Patch multiple files | File Column tutorial - YouTube

Upload Multiple Files in Dataverse : Implementation | Abhinav Prakash

I made my tasks and I get some issues:

First, when I copy and paste the attachment control outside the form (DataCardValue) , the option to "Upload file" is missing, I am using a form connected with a dataverse table inside Teams.

Second, If I keep the attachment control of the form anyway and I type this formula on the Success event of the form:

Creating a record on the Invoices Attachments table based on the Attchament control of the form.

ForAll(DataCardValue254.Attachments ,
Patch(Inventory_Invoices_Attachments, Defaults(Inventory_Invoices_Attachments),
{
Name:frmInvoice.LastSubmit.Name,
Invoice:frmInvoice.LastSubmit,
File:{FileName:ThisRecord.Name , Value:ThisRecord.Value}
}
));

It does nothing, it does not enter in the loop.

It is like the control DataCardValue254.Attachments is empty after the form submit.

And If I do Countrows(DataCardValue254.Attachments) before submit the form, it counts the amount of attachments well.

Any idea about it?

Thanks for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @EmilioRoqueta69

My recommendation, as there are .... other ways, is simply to change your initial action to be a Patch to the first table, do not do a Submit.

I know I know but Michael its a form... don't care what you want to happen either you need to capture all the data from the attachments into a Collection PRIOR to submitting, from the Attachments control, then in the Onsuccess loop through the Collection NOT the control

or change the first to a Patch, wrapped in an IfError or one of its variants and if it succeeds, then do your code below.

one of those 2 will solve your issue :-)

Was this reply helpful? Yes No
Suggested answer

sumitkp 6 on at

Like (1)

Report
Copy link

Link copied!
Hi @EmilioRoqueta69.

Regarding "when I copy and paste the attachment control outside the form (DataCardValue) , the option to "Upload file" is missing"

The copy of Attachments control from form used to work before but now it isn't maybe due to some bug but a workaround for that is to hold and drag the control under Tree View to outside of the form and from there you should be able to use it.

If you meant to use the Attachments control outside of the Form to upload multiple files, then you could use Power Automate for that purpose as stated here: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/file-column-data?tabs=webapi , there are 3 ways to upload a file to a file column in Dataverse which are:

Use Dataverse messages available to both the SDK and Web API

Upload a file in a single request using Web API

Upload the file in chunks using Web API

If you meant to use the Attachments control inside the Form:

Unfortunately, I am getting a readonly column for File Column in Dataverse.

Was this reply helpful? Yes No