Hey @vinaygkp, I came here with the exact same question. After some head scratching, I discovered you can loop through data with `ForAll()` and convert the columns in the loop.
This works:
/*
* Create some data that mimics a DB table
*/
UpdateContext(
{
locUserDataFromDB: [
{
UserName: "Daniel",
IsHungry: true,
NumTacosEaten: 12
},
{
UserName: "Django",
IsHungry: false,
NumTacosEaten: 4
},
]
}
);
/*
* Use `ForAll()` to loop through the data and return new records with converted data types.
*/
UpdateContext(
{
locUserDataLocal: ForAll(
locUserDataFromDB,
{
UserName: UserName,
IsHungry: Text(IsHungry),
NumTacosEaten: Text(NumTacosEaten)
}
)
}
);
