cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

ForAll and Attachments

Hi!!

I have a collection ( CList ) with a column that has a CodeNum.

I want to see all the attachments from my Sharepoint list that matches all the CodeNum from my CList.

 

With this formula, I was able to retrieve to my Attachment control all the columns of my Sharepoint List, except the attachments.

I guess that the formula is correct, but I can't find a way to bring the attachment's name, and be able to open the file.

 

ForAll( Clist ; LookUp( ShP_List ; ID = CodNum ; 'Has Attachments' ) ) --> is working (see picture)
 ForAll( Clist ; LookUp( ShP_List ; ID = CodNum ; 'Attachments' ) ) --> is not working HELPPPPP 
 

2020-07-09 00_23_03-.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: ForAll and Attachments

Hi @RitabPedrosa 

 

Attachment is a complex column in sharepoint and there are lots of limitations to handle with it.

The best workaround I came up with is to display all attachments into a nested gallery, please try this:

1. create a Main gallery, set Items property:

Filter(ShP_List, ID in Clist.CodeNum)

2. create a sub-gallery in the main gallery, set Items property: 

ThisItem.Attachments

3. set the Text property of label inside the sub-gallery:

ThisItem.DisplayName

4. set the OnSelect property of sub-gallery

Launch(ThisItem.AbsoluteUri)

 Snipaste_2020-07-09_17-55-08.png

Hope this helps

Sik

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: ForAll and Attachments

Hi @RitabPedrosa 

 

Attachment is a complex column in sharepoint and there are lots of limitations to handle with it.

The best workaround I came up with is to display all attachments into a nested gallery, please try this:

1. create a Main gallery, set Items property:

Filter(ShP_List, ID in Clist.CodeNum)

2. create a sub-gallery in the main gallery, set Items property: 

ThisItem.Attachments

3. set the Text property of label inside the sub-gallery:

ThisItem.DisplayName

4. set the OnSelect property of sub-gallery

Launch(ThisItem.AbsoluteUri)

 Snipaste_2020-07-09_17-55-08.png

Hope this helps

Sik

View solution in original post

Highlighted
Regular Visitor

Re: ForAll and Attachments

It Works BUT only for the first 2000 records.

 

We have the delegation problem - Does not Assume the PTE3287/20 attachment 😞

 

The Main Goal is the User to be able to open the attchment.

Do you know if we can connect the Gallery a filter all the documents on the Library?

 
Highlighted
Community Support
Community Support

Re: ForAll and Attachments

Hi @RitabPedrosa ,

 

The Attachments column can't be saved into collection, it's complex and special, we can only handle with it form the data source, why causes the Delegation Warning.

If the library has fewer than 2000 records, just ignore it.

If the library has more than 2000 records, there seems to be no better way. Please consider submitting a Support Ticket to Microsoft for further assistance. Get Help + Support 

Sik

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,841)