0

I have a document library (with document sets). And while I wanted to use enterprise metatags (so I can use nested tags) the users feel that this is too much of a confusion and would like to have two columns where the second would be filtered based on the first. I thought of using powerapps and followed plenty of examples like this one https://www.portiva.nl/portiblog/2018/11/09/creating-conditional-lookup-columns-in-sharepoint-with-powerapps but it seems like an overkill to have two sharepoint lists while I could have one. I found this topic: Filtering lookup values based on another column in another list, sharepoint online and powerapps but I can't decypher what is the logic behind the solution. and if I just try to copy and paste (replacing names) I get constantly errors.

In my scenario, I have a sharepoint list called "Project Tags" with two columns. One is Document Category and the second Document Type with a 1:N relation. Then I have the doc library where I thought of using a drop-down to represent the document categories and a lookup for the document type.

Now what I look to do is to filter the document type, based on the value of the document category. If needed, I can replace the drop-down with a lookup.

Anyone kind enough to help me out with this?

Improve this question
1

2 Answers 2

Reset to default
0

For PowerApps, you can refer to this tutorial which may be an easy option for you. You will need to first set up a source list for the relationship between Document Category and Document type(just like the region and country in the video). And then in the actual list, single text column will be enough.

Improve this answer
1
  • thanks for the link. I had found the same video, but the options they get on the video, I don't have. (see allowed values as a field type). But the principle stands true.
    – kernel52
    Apr 9, 2021 at 23:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.