Unanswered

Sharepoint Document Library connection to Powerapps

(2) Share

Report

Posted on by hussain_supari

i am trying to connect sharepoint document library to powerapps but when using 'Folder Path' , showing delegation.
my dataset is huge and it wont be possible for me to create some column and populate it 1 by 1.

Is there a way to remove delegation or to get all the data from library to Collection using ID column only?

Categories:

Connecting to Data

All responses (3)

Answers (0)

WarrenBelz 143,297 on at

Like (0)

Report

Sharepoint Document Library connection to Powerapps

The only column that is SharePoint generated already populated with data that contains any degree of Delegation ability is ID, which is only Delegable for = (equals) - not a lot of use unless you recorded this somewhere else. Title is a Text column and as I mentioned, you can add further text columns to contain things like Name and Path, which you can populate with the appropriate data when the file is created via Power Automate and then query on these.
knitr 7 on at

Like (1)

Report
Sharepoint Document Library connection to Powerapps

Hi @WarrenBelz

are there any columns that a connection to a SharePoint Document Library returns, that in fact are delegable? I'm having major problems in integrating a big library.

For now I have found out the following by FAFO:

Neither Name nor {FileNameWithExtensions 0 is not delegable (although it seems to me this should be a standard text column)

{IsFolder} is not delegable

Neither {FullPath} nor {Path} is delegable

I can't seem to find any documentation about this topic. Copilot confidently gives irrelevant answers.

Edit: Title seems to be delegable. This is doable, but would require considerably more work from my side and a process change for my use case
WarrenBelz 143,297 on at

Like (0)

Report

Sharepoint Document Library connection to Powerapps

Hi @ hussain_supari

Unfortunately 'Folder Path' is simply not Delegable with a SharePoint Document Library. The only effective way to use this value would be to have a Text field where you add the path when the file is created and you can perform a Delegable query with either equals or StartsWith. You will have to bulk back-populate your existing data, but this should be possible with Power Automate.

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