Skip to Main Content
AVEVA Product Feedback


Status Declined
Categories PI Builder
Created by Guest
Created on Aug 20, 2022

Provide drop down list of enumeration values in PI Builder

When an attribute column is added in PI Builder where you have an attribute using an Enumeration Set for it's Value Type, it would be nice to have a drop down list appear in the cells. This would allow you to choose a value out of the available options rather than typing it out manually, preventing mistypes.
  • ADMIN RESPONSE
    Aug 20, 2022
    You can already accomplish this using built in Excel feature. Steps: 1) Import into Excel the Enumeration set and the values. 2) Use built in Excel feature to restrict value entries based on a list. Here's an example on how to do this: https://blogs.technet.microsoft.com/hub/2011/06/09/restrict-data-entry-in-excel-with-lists/ 3) Make sure the appropriate column in PI Builder is configured to use this restricted list. Now you can select from the list when you populate the values.
  • Attach files
  • Guest
    Reply
    |
    Aug 20, 2022
    I disagree with the reason for declining this suggestion. Yes, it is possible to set up your own dropdown lists in Excel, but it would be much easier if PI Builder did this for the user.