Forum Discussion

vlearn's avatar
vlearn
Copper Contributor
Sep 17, 2025

Custom Attributes with 1 to Many relationship

Hi All,

I am looking to enhance an asset (report) by adding custom metadata fields, such as subscription details. However, each report can have multiple subscriptions, creating a one-to-many relationship. Since managed attributes do not support this, what is the recommended approach to address this in Purview?

1 Reply

  • Rik's avatar
    Rik
    Iron Contributor

    If the number of options is limited, you could set up a multiple choice field that contains all options. You could then select all relevant options for the asset.

    Please be warned that the multiple choice field is quite limited in it's functionality. For example, it doesn't sort alphabetically. Everything you add later, is added at the bottom. Also, it is not possible to delete options  from the list later. 

     

    Another solution could just be using a text field and using a character like ; to distinguish between the inputs.

Resources