Forum Discussion
Create a library of documents with dropdowns to filter by keywords
RoBhatt93 despite what jcgonzalezmartin has said, you will NOT need a developer for this. That's the great thing about Power Automate, Power Apps and the integration with modern SharePoint: you can do it yourself. It is not difficult to do this in Power Apps and my example below was produced in less than 15 minutes while having dinner. Fortunately my wife was out playing mahjong or I'd have been in trouble. I'm not a developer but an intranet manager. It took longer to do the screenshots!
In this example the document library is named MatrixLib and there is a column called ProjectType:
In Power Apps we've added a dropdown, named it ddProjectType and just got the distinct values from the ProjectType column of the SharePoint library:
We've then added a gallery and filtered it to show only the the documents from the library where they equal the selected item from the dropdown:
The Power Apps web part can then be embedded in a page on the site:
This is the result:
Come back with any questions if something isn't clear or you need a bit more assistance.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
jcgonzalezmartin Thanks so much for letting me know. Would a developer be building out this functionality in Power Apps, or coding it directly into the page? I saw some tutorials on how to build list filtering in Power Apps, but could not find content about documents specifically.
Also, if I were to use a developer for this, do you have any recommendations for where to find developers for what I am seeking?
RoBhatt93 despite what jcgonzalezmartin has said, you will NOT need a developer for this. That's the great thing about Power Automate, Power Apps and the integration with modern SharePoint: you can do it yourself. It is not difficult to do this in Power Apps and my example below was produced in less than 15 minutes while having dinner. Fortunately my wife was out playing mahjong or I'd have been in trouble. I'm not a developer but an intranet manager. It took longer to do the screenshots!
In this example the document library is named MatrixLib and there is a column called ProjectType:
In Power Apps we've added a dropdown, named it ddProjectType and just got the distinct values from the ProjectType column of the SharePoint library:
We've then added a gallery and filtered it to show only the the documents from the library where they equal the selected item from the dropdown:
The Power Apps web part can then be embedded in a page on the site:
This is the result:
Come back with any questions if something isn't clear or you need a bit more assistance.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserRobElliott Thank you so much this is fantastic!!
I'll be working through implementing this and will reach out with any questions.
RoBhatt93Are you looking for something more sophisticated that metadata fields?
If not, have you considered this option? https://techcommunity.microsoft.com/t5/microsoft-sharepoint-blog/structure-your-intranet-page-metadata-coming-to-sharepoint-in/ba-p/212555
Also, have you considered using Document Sets?https://mikehatheway.com/2019/07/11/recent-sharepoint-updates-modern-document-sets/
Not sure if either would help, but wanted to throw it out there in case they might or may help someone else in the future.
