Answered

Version 3.26041.15 breaks SharePoint choice/text column rendering in dropdowns

(0) Share

Report

Posted on by anthonys123

483

I have an app that's published with version 3.26013.14 and working properly. I'm trying to make some updates to a ComboBox where the data source is a SharePoint list.

The existing expression is: Sort(Filter('Employee List','Employment Status'.Value = "Employed"),Title)

I'm trying to update to: Sort(Filter('Employee List','Employment Status'.Value = "Employed",Department.Value <> "Office"),Title)

Before I got to updating the expression, I'm seeing that the values in the combo box are now appearing as HTML (see screenshot below). I did recently update the JSON formatting for the List default view but I don't think that's the issue.

When I add a Calculated column =Title, I'm getting the same HTML in the combo box when I reference it instead.

When I insert a Text Label with First('Employee List').Title it looks correct (just user name, no HTML). Confirmed that First('Employee List').calctitle is correct too.

I inserted both a new dropdown and combo box and they're rendering the same HTML value. I changed the default view in SharePoint to one that does not have formatting and see the same HTML.

And - when I do go to update the ComboBox expression to exclude items where Department eq Office, it's not working. I can use Text Labels to confirm the syntax but it's not applying to the ComboBox.

Screenshots show (1) what the HTML looks like and (2) that Title is still rendering properly for ComboBox.Seleted.Title.

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Suggested answer

Pstork1 69,462 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The solution to this is to use the plaintext() function when creating the calculated column. That will strip out the HTML formatting and leave just the text. You can then use that calculated column in your dropdown.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
anthonys123 483 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1 I tried the following and the result was blank values
Sort(Filter('Employee List','Employment Status'.Value = "Employed",Department.Value <> "Office"),PlainText(calctitle))

If you're suggesting something like plaintext(Title) in the calculated column, I'll need a little more guidance as this results in a syntax error.

EDIT: ARE WE STILL NOT ABLE TO REPLY TO REPLIES?

Ugh. I'll just post this on Reddit where they have a functioning message board.

Was this reply helpful? Yes No
11manish 2,293 on at

Like (0)

Report
Copy link

Link copied!
The HTML display issue is caused by the ComboBox using incorrect or formatted fields—fix it by explicitly setting DisplayFields and SearchFields to "Title".

The filtering issue is likely due to incorrect handling of the Department column type (Choice vs Text vs Multi-select).

Adjust the formula accordingly and ensure the correct syntax is used.

try below:

Explicitly set these properties on your ComboBox:

DisplayFields = ["Title"]

SearchFields = ["Title"]

Sort( Filter( 'Employee List', 'Employment Status'.Value = "Employed" && Department.Value <> "Office" ), Title )

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,462 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@anthonys123, I was suggesting an AddColumns() directly in the Items property of the Dropdown or Combobox. Something like this:

AddColumns(Sort(Filter('Employee List','Employment Status'.Value = "Employed",Department.Value <> "Office")),CleanColumn, PlainText(Title))

That should return a temporary Table with an additional column called CleanColumn that has the Title field stripped of HTML. You can then adjust the settings to use CleanColumn as the display field.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
anthonys123 483 on at

Like (0)

Report
Copy link

Link copied!

@11manish

I tried this once and it worked. The existing values for DisplayFields and SearchFields were [""] so I changed them to ["Title"]

To ensure I understood the solution and record my actions, I reverted back to the live version of this app, undoing everything I've worked on today. When I did so and repeated your solution, the values for Department are not being filtered out. However, the text is not displaying as HTML.

So, I'm even more confused now.

Was this reply helpful? Yes No
anthonys123 483 on at

Like (0)

Report
Copy link

Link copied!

@11manish

Inserted a new combobox and it's working as intended. I'm unable to get the original combobox to change behavior regardless of what I do. Even deleted the expression in Items. I'll have to copy all my settings over but assume this is the solution.

Was this reply helpful? Yes No
anthonys123 483 on at

Like (0)

Report
Copy link

Link copied!

Something is seriously broken. At one point the values were appearing as they should. I go to check later and it's reverted to including "Office" values.

I changed the expression from
Sort(Filter('AHT Employee List','Employment Status'.Value = "Employed" && Department.Value <> "Office"),Title)
to
Sort(Filter('AHT Employee List','Employment Status'.Value = "Employed" && Department.Value = "Office"),Title)

That changed the values to only the "Office" items. I reverted the expression and it's still only showing the "Office" items.

I delete the Items expression entirely and now I'm back to the HTML text. I see that deleting Items reverts the DisplayField and SearchField to an Assets column. I change these values back to ["Title"] and simply make the connection to the list (no expression). No expression and the items showing in the list are the correctly filtered values of "Employed" and not "Office".

Was this reply helpful? Yes No
anthonys123 483 on at

Like (0)

Report
Copy link

Link copied!

Observations

With any (literally ANY) change made to the Items expression, the DisplayField and the SearchField revert to ["Assets"]. I'm constantly having to go back and change these values to ["Title"].

Caveats: If I change the expression in the Properties bar on the right, it has no change on what's being filtered and does not change the DisplayField or SearchField. If I make the change in the expression bar, the the DisplayField and the SearchField revert to ["Assets"].

The character for "not equal" <> is not working. If I change the value to = then I get an accurate result from the list that shows only the departments that are equal to Office. If I change to <> it has no filtering effect. I've tried both using '&&' and ',' for the expression. I've also tried removing the Employee Status filter and using only the Office filter - no change.

This works: Sort(Filter('Employee List', Department.Value = "Office"),Title,SortOrder.Ascending)

This does not work: Sort(Filter('Employee List', Department.Value <> "Office"),Title,SortOrder.Ascending)

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,462 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Have you tried using Not() like this

Sort(Filter('Employee List', Not(Department.Value = "Office")),Title,SortOrder.Ascending)

That should be the same output as <> but I tend to find it works better.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
anthonys123 483 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1

Sort(Filter('Employee List', Not(Department.Value = "Office")),Title,SortOrder.Ascending) also does not filter out the Office values.

In fact, I am only seeing the Office values on one of the comboboxes.

PowerApps is broken.

Was this reply helpful? Yes No