How do I define which columns I want to see in the "Simple List" view?

[C_dric Chen]

Good day, everyone.

Earlier this week, when I was testing my app, I discovered that the system would display random, un-used columns when I impersonate another user and access a simple list via an event handler in a data visualisation:

(Truth be told, I have no idea whether this has to do with the fact that the data comes from an extended table...)

So I tried to manually define the desired columns in the UI Builder, and I found out that the UI Builder has greyed out the "Column" field:

I don't want to tell each and every future users to manually select the designed columns before they start using the app. Does anyone have any ideas how to define which columns the "Simple List" page would display?

Thanks in advance!

[Pradeep Sharma]

Hi Cedric, You can configure a list to choose which columns appear in a list, by navigating to the table list view and right click on the header -> Configure -> List layout.

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/list-admin...

- Pradeep Sharma

[Marc Mouries]

The reason that users may be presented with different columns in the list component is that users may have different views and layouts. 

If you want all users to see the same columns at all times, you can set the "columns" property. This property accepts a comma-separated list of columns to render and it overrides the view property if the columns to render are different.

@Pradeep Sharma what you say makes sense on the classic UI. Cedric here is asking about a behavior occurring in a workspace built with UI Builder.

Hit the 👍 Helpful link ↓ if this answer brings you closer to achieving your goal 

[C_dric Chen]

Hello.

For some reason, ServiceNow wouldn't let me edit the "Columns" field at all.

Does it possibly have to do with the fact that the table is dynamically defined? I made it dynamically defined because I needed to make it possible to access a simple list by clicking on a data visualisation.

[kemmy1]

I want the same columns that I selected on my simple list when they click on View All.  This could be different which each simple list.  We can grab the query from the simple list using context.props.query, why isn't there something like context.props.columns?