web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SharePoint Form in Pow...

Power Apps

Answered

SharePoint Form in PowerApps. I have a lookup column which references a document library. 5k limit is stopping me from doing so.

(0) Share

Report

Report

Posted on by NeonThunder

76

I have a lookup column in a normal SPO list. That lookup references a Document Library. There are 8k items. Now I don't want all the file items, I just want Folders. There are probably 200 folders. How can I reference just these folders? As its a document Library there is the column File Type which value "Folder" could be used.

I've tried indexing which hasn't worked. Now I have opened the form in Power Apps to get the choice field below...

Choices([@'Email Redirect Rules'].DestinationFolder)

I thought maybe StartsWith or Filter would help but doesnt seem to accept this?

How can I get around this so the lookup to the list just looks up Folder Type="Folder"

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NeonThunder,

Do you want to reference to the original column values including folder?

I think you could directly reference to the column from the document library based on the folder type.

Filter(Documents,Isfolder).ColumnName//Here is the column that your LookUp column retrieves value from

If you insist on using a Choices() function, you should modify your formula as below:

Filter(Choices([@BU].LookUp),Value in Filter(Documents,IsFolder).Test1)

Note that the BU is my list name and the LookUp is the LookUp type column in my list, Test1 is the original column where LookUp column retrieves value from the Documents

Join the conversation