Unanswered

How to send attachments to a SharePoint list through a gallery?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I have a button called 'Add Step' with the following code:

Collect(colEtapas;{ID:Last(colEtapas).ID+1; nomEtapa: "";Valores:"Valores";NumeroSequencial:CountRows(colEtapas) + 1})

When you click this button, it adds a new line "new step" in a gallery. Each line has two fields, a text entry, and a combobox with the multiple selection function enabled. I need to add a third field in the gallery row, so I can add attachments and send to a list in sharepoint. Could anyone help me with creating this attachment field in the gallery, and how do I send it to my sharepoint list? Here is my code for sending the two fields in the gallery line:

ForAll(Gallery1.AllItems;
With(
{
Id_EtapaCriada:
Patch(AG120SOLETAPA;Defaults(AG120SOLETAPA);
{
nomEtapa: ThisRecord.txtNome_Etapa.Text;
id_Etapa: ThisRecord.lbl_numero_etapa.Text;
id_solProcesso: {Id:varSolicitacaoProcessoCadastro.ID; Value:""}
}
)
};

ForAll(ComboBoxSistemas.SelectedItems;
Patch(AG120SISETAPA;Defaults(AG120SISETAPA);
{
id_Sistema:{Id:ThisRecord.ID;Value:""};
id_Etapa: {Id:Id_EtapaCriada.ID;Value:""}
}
)
)
)

);;

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I noticed that you are using Patch to update data, but currently PowerApps does not support using Patch to update attachments directly to the attachment column. Here I provide another workaround: do not apply patch and do not use the ForAll loop, upload files to SPlist when the user adds files.

1)Create a edit form and copy the attachment control to gallery:
2)Set the attachment control in gallery:
Items:ThisItem.Attachments OnAddFile:ClearCollect(Atch,Self.Attachments);SubmitForm(EditForm)
3)Set the attachment control in Edit form:
Items:Atch
4)Set the Edit Form:
Item:Gallery.Selected Visible:false

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello

I had already managed to achieve this result this way.
But what I need is to add the attachment field to the right of my gallery line, so that it always adds one more when clicking on my add step button, and somehow send this information to sharepoint, just like with my field text input and my combobox. I know that you can't add files to collections, and this is my biggest problem. Because when clicking the add step button I create a temporary record in the collection that is deleted after clicking the submit button where it contains the forall code.