Forum Discussion
Create a library of documents with dropdowns to filter by keywords
Hello! I am building a Communication Site in SharePoint and want to build a page that allows me to have project files saved with certain keywords (e.g., project type), then to have a dropdown for "project type" that filters the resulting documents that appear. Is this search capability possible to include or develop? What would be the best way to do this? Any advice is greatly appreciated.
Thank you!
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
7 Replies
- Yes, this is something that can be developed on SharePoint. You will need a SharePoint Developer to build it for you
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 User
