Power App Filter by Partial Text

When I tried to filter a column by a partial match I always revieced an error message. My first expression looked like:

Filter('[dbo].[V_DIM_LEDGER_ACCOUNT]', cbbCCCUPJId.Selected.Type in RightsString)
Code-Sprache: JavaScript (javascript)

By using this expression I never got a match (e.g. CC in CCCUPJ) !!! After visiting a couple of forums and entries, the solution is as simple as this:

Filter('[dbo].[V_DIM_LEDGER_ACCOUNT]', cbbCCCUPJId.Selected.Type in Text(RightsString))
Code-Sprache: JavaScript (javascript)

You just have to “convert” the column into text – even as power apps already says it’s a text in the intellisense… Never mind, whenever you struggle to do a match, hope this will help you!