cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaylou
Level 8

cascading drop down in document library

Hi all,

I am trying to get a solution to create cascading dropdown when uploading new documents to an SPO document library.

I saw a post for 3 column drop down to SP lists, but I believe a custom list does not act the same as a custom library (But I may be wrong Smiley Happy). 

 

We are scanning in all our paper docs to a library, and moving all docs from shared drives to the same library. 

In the library I added 3 required columns, Location,source,doctype

There can be up to 20 sources and each source can have up to 50 doc types. 

Each location has it's own combonation of LOC/SOURCE/DOC TYPE

 

I am trying to reduce errors by cascading from location to source to doctype

When Location#1 is chosen I only want the sources for that location, then when the location and source are chosen I only want the doc types for that loc/source combo.    

 

Is this possible?  If so, can anyone point me to a how to blog?

 

TIA,

Joe

 

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: cascading drop down in document library

Hi,

 

The available cascading dropdown example are all related to SharePoint list.

A sample one:

SharePoint: Cascading Dropdowns in 4 Easy Steps!

 

By the way, for the library in PowerApps, currently it is not possible for PowerApps to get the related file, it would only be available to work with the corresponding property field.

SharePoint Document Libraries in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: cascading drop down in document library

@jaylou I also have a video on PowerApps Cascading Menus if it helps.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
jaylou
Level 8

Re: cascading drop down in document library

Thank you I will check all of these out !!

Joe
sealtiels
Level: Powered On

Re: cascading drop down in document library

I have an app where I used distinct to create cascading dropdowns. All works fine, except that the field is not updated in my sharepoint list. The property UPDATE is set to Dropdown.Selected, but even the persona selects the right value in the dropdown the value is not updated in the sharepoint list.

I read something that Distinct only returns a table with one unique column called "Result" with no ID. Is that the reason why the UPDATE property odoes not work.

How do I make sure the value selected through the cascading menu will update in the sharepoint list?

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 229 members 4,936 guests
Please welcome our newest community members: