I have 4 fields inside my Canvas App to create and populate a collection named Colrow, as follow:-
Now inside the Screen OnVisible i created this empty collection:-
ClearCollect(Colrow,{
Article:Blank(),
Description:Blank(),
Returnable:Blank(),
Qty:Blank()
});
and inside the button OnSelect i set this formula to populate the collection :-
Patch(Colrow,Defaults(Colrow),{
Article:Article.Text,
Qty:Qty.Text,
Description:Description.Text,
Returnable:Returnable.Text
});
but the last formula is raising this error:-
The function Patch has some invalid arguments
as follow:-
any advice please?
Thanks
Hi @johnjohn123 ,
Maybe you could try to use the following formula:
Screen OnVisible:
ClearCollect(Colrow,{Article:"",Description:"",Returnable:"",Qty:""});
Best Regards,
Charlie Choi
@vish3027 but why Patch with defaults should be able to add items to the collection, am i wrong?
@johnjohn123 , You can try Collect function instead of Patch.
Collect(Colrow,{
Article:Article.Text,
Qty:Qty.Text,
Description:Description.Text,
Returnable:Returnable.Text
});