Changing Display Value, Removing the ; and #

[ez1138]

Pulling from a "choice" list, I'm seeing the value come through in my PowerApps as the following...

;#Choice 1;#Choice 2;#

Here's the code I'm using for the field...

First(Filter('Company-Agency', 'Company Name' = Body_Company.Text)).'Agencies Served - Calc'

This code is due to using multiple lists within the PowerApp.  It works perfect outside of choice fields.  I had to use the SharePoint workaround the be able to see the choice field as an option in PowerApp (workaround of creating a choice column as a single line text, another column as a calc to pull that choice column field (that was single line text), deleting that original choice then creating a real choice column with a multiples). 

The Choice 1 and Choice 2 are correct...I just need to remove those ; and #.  Ideally I would like the following....

Choice1, Choice 2

As a bonus, is there a way to display it as Choice 1 in line 1 and Choice 2 right below it?

Thanks for any insight!!!

[WarrenBelz]

Hi @ez1138 ,

If you are pulling from a "complex" field such as a choice field, you might try .Value instead of .Text

First(
   Filter(
      'Company-Agency', 
      'Company Name' = Body_Company.Value
   )
)
.'Agencies Served - Calc'

Please click and accept as Solution if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[ez1138]

Thanks for the reply.  I tried that...no dice there.

[v-siky-msft · Accepted solution]

@ez1138 

Could you show the data construct of the SharePoint list?

How did you define the 'Agencies Served - Calc' column?

While the source of the issue may be from SharePoint, try this as an alternative

Trim(Substitute( First(Filter('Company-Agency', 'Company Name' = Body_Company.Text)).'Agencies Served - Calc'  ,";#",Char(10)))

Sik

[ez1138]

Worked awesome.  Thanks!!!