Delegation sharepoint document library

(1) Share

Report

Posted on by Massingc1983

122

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Massingc1983

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

Was this reply helpful? Yes No
Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No