cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashwnaidv100
Helper III
Helper III

Create multiple Attachments in single powerapp screen and share to sharepoint list.

How should I create multiple attachments datacards in single powerapp editform screen and send all the attached files to sharepoint list in attachments. I tried to add multiple attachments but they send only one file to sharepoint from first attachment datacard. I need to collect all the files attached in all the attachemnt datacards in sharepoint list. Any way, hack or method would be helpful.

16 REPLIES 16

Microsoft Advice

So, it should be possible, but you would have to do this in a custom way. Your best bet is to use custom cards and add additional upload controls. What you would need to do, when the form is submitted, is patch these extra files as attachments.  You may need to use Power Automate in combination with Power Apps to achieve this.



See attachment

Thanks @KayBains !

ashwanidv100
Frequent Visitor

Unfortunately I don't have access to my this account. I'm started using other account which is @ashwanidv100 

Thanks @KayBains for you responses and answers.

@Lilian1331 ,

Q. How did you resolved this Issue?

A. I was able to consult it through to on my project instead of hitting this wall. I did used multiple attachments using one datacard. As It was yearly data submission at once. I was able to manage to distribute on a monthly basis. So That helped me to save a lot files to not be submit at once but frequently. So In my part was consulting on the possible ways to manage things out, if the system is having limitations.

ashwanidv100
Frequent Visitor

@Lilian1331 ,

 

I was novice at that time, But if you ask me now. 

 

I would say don't use patch function, but simply use power automate to manage it somehow. 

 

1. Create a single list and create a 3 Editforms for the same list with different names, Use the attachment datacard. 

2. When submit the forms, Use power Automate and keep the attachments in sharepoint docs or wherevers you like to store them in a specific folder.

3. Use unique name for each folder can be created easily by following a right nomenclature.

4. Generate the link and store it in the SharePoint list column and may call it 'Link to attachments' or 'Something else you like'.

5. And it just instead of storing the files directly to list record it will have a path of where its stored in a SharePoint docs.

 

Hope this help you somehow to guide you to think about it.

 

Ash

 

KyleJ
Helper II
Helper II

@Lilian1331 
@KayBains @ashwnaidv100 
I have a solution.

When you patch an item, you are able to save the patch to a variable, giving you the newly created ID number. From there, you can patch updates to that same record via ID. 

We know, you can

Patch(YourDatabase,Defaults(YourDatabase),{Field:"Value"},form1.Updates)

But lets expand on this. In ONE SINGLE submission, we need to accomplish a few things. You can first submit the record as above, with 1 of your attachments being submitted. But, lets go ahead and grab the newly created ID by wrapping a Set Variable around the Patch Function. 

Set(PatchedID,Patch(YourDatabase,Defaults(YourDatabase),{Field:"Value"},form1.Updates))

The above code will now submit the record and all fields, and it will add the first attachment, and return to the variable the ID (among other info) 

We can now execute, two additional patch functions. 

Patch(YourDatabase,LookUp(YourDatabase,ID=PatchedID.ID),Form1_1.Updates);
Patch(YourDatabase,LookUp(YourDatabase,ID=PrevPatchedID.ID),Form1_2.Updates);

All together, these three functions (the first being the "Set(Patch())" ) all together will submit multiple attachments from multiple sections of 1 singular form, into 1 single record. 
Finished code should look about like this: 

 

 

 

Set(PrevPatchedID,Patch(Datasource,Defaults(Datasource),{
    Title:TextInput.Text,
},Form1.Updates));

Concurrent(
Patch(Datasource,LookUp(Datasource,ID=PrevPatchedID.ID),Form1_1.Updates),
Patch(Datasource,LookUp(Datasource,ID=PrevPatchedID.ID),Form1_2.Updates)
)

 

 

 




ashwanidv100
Frequent Visitor

Thanks @KyleJ , 

 

Yes, This is one of the possible solutions that someone can think of and may use the same 👏

 

The main intension to my proposed solution was to store the attachments handy and available in structured way (folder wise). Because in generally we ended up using power automate as a part of power suite solution So those files can come handy for sending it forward and do more with that.  

 

Ash

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,551)