Hi All!
Everything that you will see here was working just fine yesterday with every app, now all of them suddenly bring Date Values as number. I Tried a lot of things, remade the collection, changing the lenguage, force the column to date format... But nothing works, out of nowhere it has happened in every app i made/try to collect Date in collections.
ClearCollect(
colRelatedUsersTemp;
ForAll(
Table(ParseJSON('PowerApp->SimuladordeBarramento'.Run(***SQLqueryInHere***).json).Table1);
If( Text(Value.CONTRACT) = "PLCGR";
{
refRecebimento: Text(Value.DOCK_REGISTER_NO);
dataRecebimento: DateTimeValue(Value.ORDER_DATE);
valorUnitCompra: Value(Value.FBUY_UNIT_PRICE);
unidMedida: Text(Value.BUY_UNIT_MEAS);
quantidade: Value(Value.QTY_ARRIVED);
projeto: Text(Value.PROJECT_ID);
ativSeq: Text(Value.ACTIVITY_SEQ);
codMaterial: Text(Value.PART_NO);
descMaterial: Text(Value.DESCRIPTION);
ordemCompra: Text(Value.ORDER_NO)
})
))
Here are the Result:
But Even if i try a simple: ClearCollect(colDate;{date:Today()}), it brings me a broken date value as number.
As i said, i tried many thins, and it started to happen yesterday, before was perfect, and now it happens in every app, turning date manipulation almost impossible.
PowerApps Versions that i used in tests: 3.23061.24 ; 3.23063.9 ; 3.23055.19(older)
Thanks in advance!
