Skip to main content
Member
Jul 16, 2026 7:41 AM UTC
Solved

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

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.

sameburnAnswer
Employee - Advisor
Aug 6, 2026 11:47 AM UTC

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

1 reply

sameburnEmployee - AdvisorAnswer
Employee - Advisor
Aug 6, 2026 11:47 AM UTC

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