HI all, I'm making a app. I get the datas with this cod
Collect(UpdateProdutoQua; Filter('[dbo].[E_RECEBIMENTO_PRODUTO_QUALIDADE]';ID_VEICULO = varIdVeiculoQua && DESC_PROD = Gallery6.Selected.DESC_PROD) )
I need put the number of rows in eache line, I can add other line in this coolection, How Can I do this ? I tried put Set(value:value +1) but this cod not run in for all. Thanks!!
Solved! Go to Solution.
Hi @vjcaldeira1 ,
You want to add a number column to your collection? Try this
ClearCollect(
colTemp;
Filter(
'[dbo].[E_RECEBIMENTO_PRODUTO_QUALIDADE]';
ID_VEICULO = varIdVeiculoQua && DESC_PROD = Gallery6.Selected.DESC_PROD
)
);;
Clear(UpdateProdutoQua);;
ForAll(
colTemp;
Collect(
UpdateProdutoQua;
Last(
FirstN(
AddColumns(
colTemp;
"RowNumber";
CountRows(UpdateProdutoQua) + 1
);
CountRows(UpdateProdutoQua) + 1
)
)
)
);;
Clear(colTemp)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @vjcaldeira1 ,
You want to add a number column to your collection? Try this
ClearCollect(
colTemp;
Filter(
'[dbo].[E_RECEBIMENTO_PRODUTO_QUALIDADE]';
ID_VEICULO = varIdVeiculoQua && DESC_PROD = Gallery6.Selected.DESC_PROD
)
);;
Clear(UpdateProdutoQua);;
ForAll(
colTemp;
Collect(
UpdateProdutoQua;
Last(
FirstN(
AddColumns(
colTemp;
"RowNumber";
CountRows(UpdateProdutoQua) + 1
);
CountRows(UpdateProdutoQua) + 1
)
)
)
);;
Clear(colTemp)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You are fantastic, Thanks so much for help me ......
User | Count |
---|---|
205 | |
94 | |
87 | |
47 | |
43 |
User | Count |
---|---|
252 | |
104 | |
103 | |
62 | |
57 |