Uploading Attachments to a sharepoint list record using gallery to select

(1) Share

Report

Posted on by SB-05021429-0

Hi.

I have a gallery which shows a series of word files in a folder, which the user can select with a checkbox

Along with various bits of form data collected in the app, at the end the user can submit the data to a single record in a sharepoint list.

Handling and submitting the data collected in the forms is easy, but I am stuck at how to get the attachments selected in the gallery in the sharepoint list.

The purpose is to build a document at the end of the process using power automate, some template word files , and the attachments the user has selected.

Any idea's?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

The proper way would be to have an attachment control on the Form. When people select them in your gallery, add them to the Attachment Control, so that they are automatically added to item in SharePoint.

The other way would be to pass a reference of them to Power Automate and it do it.

I would use the form Control.

Here are some references for learning. Use the OnCheck / UnCheck events to add/remove it to the form control, which will be on a Data card on the Form.

Power Apps Attachment Control - How to Use - SharePoint & Microsoft Power Platform Tutorials - SPGuides

Attachments control in Power Apps - Power Apps | Microsoft Learn

UPLOADING FILES TO SHAREPOINT WITH THE NEW POWERAPPS V2 CONNECTOR

PowerApps Attachment Control: Complete Guide & Tips

Cheers

Was this reply helpful? Yes No
SB-05021429-0 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks @FLMike, this is what I have been understanding through research. I have looked the links you kindly shared. Whilst they show loads of useful info on the attachment control, I couldn't see anything about how to get the attachment control to work with the gallery.

Currently my Gallery (RAMSGallery) data source is a folder within sharepoint containing the word documents. I have a Sharepoint list (SafetyList) where ultimately these attachments will go.

Any other suggestions or tips how to get this all linked up would be great.

Was this reply helpful? Yes No
WarrenBelz 155,444 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @SB-05021429-0,

You did not specify the type of Folder, but assuming it is a SharePoint document library, you need a Flow as below and send two ID references - one from the Library file and the other the List record you want to attach it to.

If you are selecting multiple files, run the Flow inside a ForAll statement (example)
ForAll( Filter( GalleryName.AllItems, CheckboxName.Value ) As _Files, FlowName.Run( YourTargetListID, YourListID, _Files.ID ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
SB-05021429-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hey

I might well be being very dumb on this as some of the terminolgy is a little new to me, and I am quite rusty on some other bits but I believe I did create the flow successfully.

I have never triggered a flow from Powerapps, so when I built the script as you instructed (OnSelect on a button), I must have done something wrong or not understood what you ment.

Thanks in advance!

Simon

Was this reply helpful? Yes No
WarrenBelz 155,444 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SB-05021429-0,

I posted an example of the required structure - the references will depend on your values. Firstly, you are missing .AllItems from the Gallery reference and if you are using a Modern Checkbox, you need .Checked, not .Value (which is a Classic Checkbox). You are also going to need the ID of the List record you want to attach it to (as per the example Flow)

Was this reply helpful? Yes No