I have been having trouble accessing the Attachments of a SharePoint Data source.
I have been receiving the error, "This Specified Column is not accessible in this context." I have one Gallery connected to a collection where it works, and another connected to a SharePoint List where it doesn't work. Both of these have the Exact Same Function in their On Select methods.
I've done a lot of looking and cant find the rule that govern if the Attachments are accessible or not. If anyone knows the rules and would be willing to share them, That would be very appreciated.
Thank you in advance.
@AlekE ,
As I mentioned, a Collection does not contain the attachment file content. You need to access it by looking up the data source (example it an item in a Gallery formed by this collection is selected, to view the first attachment with this in the Image of an Image control
First(
LookUp(
SPList,
ID = GalleryName.Selected.ID
).Attachments
).Value
Please click Accept as solution 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 Thumbs Up.
Visit my blog Practical Power Apps
I'm not showing the attachments directly in the gallery, I'm Collecting it into a collection and assigning it an additional value so it can be displayed on a different screen.
@AlekE ,
The strange thing is that a collection does not contain attachments - are you sure it is not the other way around? How are you trying to show the attachments in the gallery ?
Yes I have attachments enabled in SharePoint,
The location of this error is in a Gallery with the SharePoint as it Data Source in the OnSelect method,
I can seem to access every column except he Attachments Column
I can seem to access it in another Gallery that has a Collection as a Data Source.
That seems to be the only difference that I can find between the two.
Hi @AlekE ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution 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 Thumbs Up.
Visit my blog Practical Power Apps
Hi @AlekE ,
Assuming you have attachments enabled in SharePoint (which is the default setting unless you have changed it), where are you getting this message ?