SOLVED

Dynamic Dropdown in SharePoint Document Library

%3CLINGO-SUB%20id%3D%22lingo-sub-882735%22%20slang%3D%22de-DE%22%3EDynamic%20Dropdown%20in%20SharePoint%20Document%20Library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-882735%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%20Everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20can%20i%20create%20dynamic%20dropdowns%20in%20an%20O365%20SharePoint%20document%20library%3F%3C%2FP%3E%3CP%3EDo%20to%20tenant%20and%20license%20issues%2C%20it%20is%20only%20possible%20to%20solve%20the%20problem%20within%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20want%20to%20tag%20Documents%20to%20different%20groups%2C%20depending%20on%20the%20first%20dropdown%20(e.g.%201st%20dropdown%20%3D%20Country%20--%26gt%3B%202nd%20dropdown%20%3D%20Germany%2C%20Austria%2C%20...)%20to%20get%20rid%20of%20the%20current%20folder%20system.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFelix%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-882735%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-882927%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Dropdown%20in%20SharePoint%20Document%20Library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-882927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417466%22%20target%3D%22_blank%22%3E%40FelixDiehlmann%3C%2FA%3E%26nbsp%3BI%20think%20the%20best%20way%20to%20do%20this%20is%20to%20use%20a%20canvas%20PowerApps%20form%20using%20your%20document%20library%20as%20the%20data%20source.%20That%20way%20you%20can%20then%20have%20cascading%20dropdowns.%20With%20a%20default%20SharePoint%20form%20you%20can't.%20Come%20back%20to%20me%20if%20you%20need%20a%20step-by-step%20or%20screenshots.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3EMicrosoft%20Flow%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885112%22%20slang%3D%22de-DE%22%3ERe%3A%20Dynamic%20drop-down%20in%20SharePoint%20Document%20Library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885112%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20Help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithin%20one%20Tenant%2C%20your%20solution%20would%20be%20perfect.%3C%2FP%3E%3CP%3ESadly%2C%20we%20currently%20use%20two%20tenants%20and%20are%20not%20able%20to%20use%20PowerApps%20in%20the%20specific%20tenant.%3C%2FP%3E%3CP%3EIs%20there%20a%20possibility%20to%20only%20use%20Java%20Script%20to%20create%20the%20dynamic%20dropdown%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFelix%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Everybody,

 

how can i create dynamic dropdowns in a O365 SharePoint document library?

Do to tenant and licence issues, it is only possible to solve the problem within SharePoint.

 

We want to tag Documents to different groups, depending on the first dropdown (e.g. 1st Dropdown = Country --> 2nd Dropdown = Germany, Austria, ...) to get rid of the current folder-system.

 

Do you have any suggestions?

 

Thanks a lot!

 

Cheers

 

Felix

2 Replies
best response confirmed by Steve Pucelik (Microsoft)
Solution

@FelixDiehlmann I think the best way to do this is to use a canvas PowerApps form using your document library as the data source. That way you can then have cascading dropdowns. With a default SharePoint form you can't. Come back to me if you need a step-by-step or screenshots.

 

Rob
Los Gallardos

Microsoft Flow Community Super User

@RobElliott Thanks for your Help!

 

Within one Tenant, your solution would be perfect.

Sadly, we currently use two tenants and are not able to use PowerApps in the specific tenant.

Is there a possibility to only use Java Script to create the dynamic dropdown?

 

Thanks a lot!

 

Cheers

 

Felix