Change Collection column data type

[jernejp]

Hi,

I'm fetching data from my database using the Filter function.

There's a column "customer" that is a Boolean type in the database, but in the application I want to change it to String. Is this possible? I've tried searching but came up with nothing.

[Jeff_Thorpe · Accepted solution]

You can add a column to the filtered results that show the string version of the customer boolean column.

Example:

AddColumns(Filter(...), "CustomerStringValue", Text(customer))

This creates a new column called "CustomerStringValue" that will have the text value of the customer boolean column.

[jernejp]

Thank you!