Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jack Kao]

Hi Everyone,

Currently I have a collection that is populated with a single record from a Common Data Service entity. On my page I have a couple of labels that display fields from that collection. For example in my entity I have a field called ‘Description’. Currently I can show this on the PowerApps page via the formula: First(Collection_Name).Description. But when I try to apply the same formula to a field that came from an option set, I’m getting a data type is not supported for evaluation error. I was wondering if there was a way to display a field from a collection that originally came from an option set field in a CDS entity.

Thanks!

——————————
Jack Kao
——————————

[Luc Vandael]

Hi Jack,
What helped me in using option set and lookup values from PowerApps is the realization that the “references” used are not fields but entities on their own.

So First(Collection_Name).YourOptionSet.Value should be possible.

An Example: First(colInvoiceHeaders).Currency.’Currency Name’

——————————
Luc Vandael
Business Analyst
Tomra
Haasrode
——————————
——————————————-

[Mark Pearson]

Are you using the same filter that you use for the collection? The Collection is a result so unless there is only one row in the source it would need a filter to get that result.  So is the label. text something like:  First(Filter(source,Col-?)).Description

——————————
Mark Pearson
National Operations Manager
61409321547
——————————
——————————————-