Isse with Patch function

[simms7400]

Hi Team -

I have a form that I need to patch from.

I'm trying to patch a SP List called "RD_Partnership_List" and Patch NULL to two column values - Portfolio_ID & Portfolio_Alias.

Patch(RD_Partnership_List,{ID:DataCardValue90.Text}, {Portfolio_ID:"diditwork" , Portfolio_Alias:Blank()})

DataCardValue90.Text represents that node on my CURRENT form that I am Patching in the list RD_Partnership_List. This executes but I don't see any changes.  Can anyone let me know where I may be going wrong?

Portfolio_ID & Portfolio_Alias are not choice/drop fields.   Thank you!

[mdevaney · Accepted solution]

@simms7400 

So close... you almost had it!

Patch(
    RD_Partnership_List,
    LookUp(RD_Partnership_List,ID=Value(DataCardValue90.Text)),
    {Portfolio_ID:"diditwork", Portfolio_Alias:Blank()}
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[v-siky-msft]

Hi @simms7400 ,

Syntax: Patch( DataSource, BaseRecord, ChangeRecord1 )

The <Base record> is the record you want to patch, so you have to use LookUp function to find out the record your form shows, and ID column is number type, you should use Value function. Please modify your formula as below:

Patch(RD_Partnership_List, LookUp(RD_Partnership_List, ID=Value(DataCardValue90.Text)), {Portfolio_ID:"diditwork" , Portfolio_Alias:Blank()})

 Best regards,

Sik

[simms7400]

@mdevaney 

Thank you so much, that worked like a charm!

@v-siky-msft   Thank you for your input!

I do have one more question. What is the best way to track a ComboBox field changing from populated to empty (user selection on an edit form)? I ask because that its when I need to execute the patch statement when the ComboBox box on one of my edit forms goes from populated to null.

Thank you!

[simms7400]

I found this article, seems easy enough:

https://wonderlaura.com/2018/04/19/powerapps-notify-on-field-change/

[mdevaney]

You are on the the right track. Definitely use the OnChange property of the ComboBox to do this.