web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps The function Patch has...

Power Apps

Unanswered

The function Patch has some invalid arguments

(0) Share

Report

Report

Posted on by johnjohn123

3,506

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

vish3027 434 on at

Like (0)

Report
Copy link

Link copied!
@johnjohn123 , You can try Collect function instead of Patch.

Collect(Colrow,{ Article:Article.Text, Qty:Qty.Text, Description:Description.Text, Returnable:Returnable.Text });

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@vish3027 but why Patch with defaults should be able to add items to the collection, am i wrong?

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @johnjohn123 ,

Maybe you could try to use the following formula:
Screen OnVisible:
ClearCollect(Colrow,{Article:"",Description:"",Returnable:"",Qty:""});

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation