Skip to main content
Member
July 16, 2026
Question

Retrieving a list of members in a parameter in Excel including both Name and Description

  • July 16, 2026
  • 1 reply
  • 40 views

Hi,

I’ve had an issue trying to use parameters to retrieve both names and descriptions of entities in Excel using a parameter.

I use a Member List parameter with a filter of entities.

In Excel, if I tick ‘Description’, sometimes I get only descriptions; and sometimes I get both names and descriptions, which is the desired behavior (the client wants to be able to choose entity by their names, and I need the code in the parameter to make the XFGetCell formulas work).

Is there any option here I’m not aware of?

I’ve found a solution, which is to create a XFBR rule that feeds a Delimited List parameter with strings including both name and description. It works fine. But I’d like to make sure I didn’t miss something obvious here.

1 reply

Advisor
August 6, 2026

Hi ​@StephaneS 

I think this is determined by the Display Member property on the Member List Parameter itself e.g. Name, Description or Name and Description. 

 

See advice from Design & Reference e.g

Specify Member List Settings

Hope this helps

Sam