i have built a file explorer that is supposed to display files and folders from two different SharePoint-DocumentLibaries DL_Permission and Dokumente2. The respective SharePoint-Document Libary is selected using a dropdown menu. So far, i have implemented it such that the variable varSelected Libary determines the database.
OnChange-Property of Dropdown
Items-Property of File Explorer (Gallery) --
Filter(varSelectedLibary, StartsWith(FolderPath_delegable, varFolderPathSelectionFile))
So far, so good! It works perfectly up to the well-known delegation limit of 2000 records. However, since i have more than 10000 files in the document libary, so i need to rely on delegation.
According to Microsoft's documentation, fields like FolderPath and FileNameWith Extension do not support delegation. To adress this, i created single-line text columns in my libaries for.
It seems the issue lies with the variable varSelected Libary. Does anyone have a tip on how i can make this variable delegable?
Thank you
Adam