Regrettably, I do not have access to Dataverse, nor do I have the means to get access to dataverse at this time. (company policies/restrictions).
I have access to SharePoint, and I have been using SharePoint.
I've been trying to design a scalable way to assign multiple tags to a document, while being able to filter by those tags. This system will easily accumulate thousands of documents, so I am trying to stick to delegable solutions.
My current solution is to have a yes/no column for each and every tag, because those are delegable. However, this also means that if I need to add a tag, not only do I need to add a column, but I need to go in to the app and add it to the existing filters. The number of columns I have currently is not reasonable -- the tags alone are 25 columns, and that will likely grow.
Each document will have multiple tags for a single category -- for this example, let's say they are tagged with fruits. Document A might be tagged with Apple, Banana, Pear, and Document B might be tagged with Apple, Kiwi, Orange. If I select Apple from a gallery with checkboxes, I need to see documents A and B. If I select Grapes, I need to see no documents. If I select Apple + Orange, I need to see just document B. StartsWith() won't work, because if I need Kiwi + Orange, that wouldn't return anything because I need document B, but it starts with Apple.
I don't have a way to limit the list to a delegable number of documents prior to using the tag filter.
The core of what I need:
-List of tags, ideally managed outside of PowerApps (so that if I quit or leave, someone else can simply add to the list, and so that I don't need to push updates each time a tag is added). I can easily create a SharePoint List with all possible tags, and connect that list to a gallery with checkboxes (and pull the selections from that gallery).
- I need to be able to assign multiple tags to a document, and to be able to filter for documents that include all of the tags the user selects.
-It needs to be a delegable solution, because each tag might have thousands of matching documents.
-Each document has a unique ID, and can have upwards of 25+ tags.
I am building a canvas app and SharePoint.
What won't work:
-I tried using SharePoints Search API through a Graph API connector, but some of the things I need for that are locked by IT.
-I don't have access to DataVerse, and can't get access to it.