Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Delegation sharepoint document library

(1) ShareShare
ReportReport
Posted on by 118
Hi 
 
I am using the following filter on a powerapps gallery to view attachments from a folders in a sharepoint document library.
 
Filter('Requisition Folders', 'Folder path' = "Requisition Folders/" & DCReqNumberMainView.Text &"/")
 
There are now over 7000 folders in the library so i am struggling with delegation. 
 
Can anyone advise or point me in the direction of a reliable way to overcome this issue. 
 
Chris 
  • Suggested answer
    Ravindra Jadhav Profile Picture
    Ravindra Jadhav 240 on at
    Delegation sharepoint document library
    Hii,

    Delegation sharepoint document library

    As @WarrenBelz Mention 
    You need to create text type column in your document library and then search the name of that folder in that text type column and also you can take help of power automate flow to create the text column in your document library 
     
     
    Please Closed the Question, Mark it Solved 
     
    If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping
     
    Thank You
    Ravindra Jadhav
  • WarrenBelz Profile Picture
    WarrenBelz 145,343 on at
    Delegation sharepoint document library
    You will continue to struggle with Delegation if you are trying to filter on the Folder Path or File Name, which are simply not Delegable. You need to add some Text fields to the Library and populare them with the relevant data (you can do this with a Flow when the file is created) and then your queries will be Delegable using either equals (as in your example) or StartsWith()
     
    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    Buy me a coffee
  • Suggested answer
    FLMike Profile Picture
    FLMike 27,710 on at
    Delegation sharepoint document library
    Hi,
     
    Please, provide screen shots of your actual issue, as I see nothing up there that gaurantees delegation issues.
     
    However, as a total guess of your issue do this.
     
    With(
         {FolderPathValue:  "Requisition Folders/" & DCReqNumberMainView.Text &"/" },
           
         Filter('Requisition Folders', 'Folder Path' = FolderPathValue)
    );
     
     
    Now that being said, if you still have an issue, then we have to make it so that instead of using strings, we would need to create a Numeric representation of the path to search on
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard