Answered

Save a record (Patch)

(0) Share

Report

Posted on by Kosenurm

802

I have a function in my app whereby I want the user to be able to Save their progress so far (Patch (defaults) a new row to a Dataverse table), and then save this record as they go along.

I don't want to use a Form, as I find them ugly.

I have found a way to save the GUID of the saved record into a variable. I then am trying, when the user makes changes to this record and want to 'save' it and overwrite the dataverse row with the latest data, using the below code, but it's not working. Any ideas?

Basically, if the variable is not blank (so the user has already saved which Sets the variable), do a Patch to overwrite this with the latest data.

If(!IsBlank(VendGUID.'Canary Vends', First(Filter('Vends', 'Vends' = VendGUID.'Vends'),
Patch('Vends', 
{'Name of Submitter': User().FullName},
{'Change Request Number': CHGNumber_TI.Text},
{'Management group': MgmntGrp_CBB.Selected.Value},
{'DevOps Project Name': DevOpsProject_CBB.Selected.name},
{'DevOps Repo Name': DevOpsRepo_CBB.Selected.name},
{'Subscription Name': 'LZ-Sub-Name_TI'.Text},
{'Subscription type': SubType_CBB.Selected.Value},
{'Cost Center': CostCenter_CBB.Selected.'Cost Centre Code'},
{'Network - vnetCidr': vnetCidr_TI.Text}));

Once I have this sorted, if the variable is blank, I will do a Patch (defaults) action to create a new row.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Abhilash_Swain 901 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kosenurm ,
If(!IsBlank(CanaryVendGUID.'Canary Vends',
Patch('Canary Vends', First(Filter('Canary Vends', 'Canary Vends' = CanaryVendGUID.'Canary Vends'))
{'Name of Submitter': User().FullName},
{'Change Request Number': CHGNumber_TI.Text},
{'Management group': MgmntGrp_CBB.Selected.Value},
{'DevOps Project Name': DevOpsProject_CBB.Selected.name},
{'DevOps Repo Name': DevOpsRepo_CBB.Selected.name},
{'Subscription Name': 'LZ-Sub-Name_TI'.Text},
{'Subscription type': SubType_CBB.Selected.Value},
{'Cost Center': CostCenter_CBB.Selected.'Cost Centre Code'},
{'Network - vnetCidr': vnetCidr_TI.Text})

, "");

The "First(Filter('Canary Vends', 'Canary Vends' = CanaryVendGUID.'Canary Vends')" will help to patch the Item you want. So it should be inside patch. For easy identification I made the patch section in bold and if section italic.

Please give a like to support and accept it if I answered you . 🙂

Was this reply helpful? Yes No
Kosenurm 802 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your help.

When I input this, as advised, I get an error of 'Invalid number of arguments: received 3, expected 1"... ??

If(!IsBlank(CanaryVendSave.'Canary Vends', Patch('Canary Vends', First(Filter('Canary Vends', 'Canary Vends' = CanaryVendSave.'Canary Vends')), {'Name of Submitter': User().FullName}, {'Change Request Number': CHGNumber_TI.Text}, {'Management group': MgmntGrp_CBB.Selected.Value}, {'DevOps Project Name': DevOpsProject_CBB.Selected.name}, {'DevOps Repo Name': DevOpsRepo_CBB.Selected.name}, {'Subscription Name': 'LZ-Sub-Name_TI'.Text}, {'Subscription type': SubType_CBB.Selected.Value}, {'Cost Center': CostCenter_CBB.Selected.'Cost Centre Code'}, {'Network - vnetCidr': vnetCidr_TI.Text}), "");

The variable is being set on another save button as...

Set(CanaryVendSave, Patch('Canary Vends', Defaults('Canary Vends'), {'Name of Submitter': User().FullName}, {'Change Request Number': CHGNumber_TI.Text}, {'Management group': MgmntGrp_CBB.Selected.Value}, {'DevOps Project Name': DevOpsProject_CBB.Selected.name}, {'DevOps Repo Name': DevOpsRepo_CBB.Selected.name}, {'Subscription Name': 'LZ-Sub-Name_TI'.Text}, {'Subscription type': SubType_CBB.Selected.Value}, {'Cost Center': CostCenter_CBB.Selected.'Cost Centre Code'}, {'Network - vnetCidr': vnetCidr_TI.Text}));

Was this reply helpful? Yes No
Verified answer

Abhilash_Swain 901 on at

Like
a
(1)

Report
Copy link

Link copied!

@Kosenurm ,
My Bad.

If(!IsBlank(CanaryVendGUID.'Canary Vends'),
Patch('Canary Vends', First(Filter('Canary Vends', 'Canary Vends' = CanaryVendGUID.'Canary Vends'))
{'Name of Submitter': User().FullName},
{'Change Request Number': CHGNumber_TI.Text},
{'Management group': MgmntGrp_CBB.Selected.Value},
{'DevOps Project Name': DevOpsProject_CBB.Selected.name},
{'DevOps Repo Name': DevOpsRepo_CBB.Selected.name},
{'Subscription Name': 'LZ-Sub-Name_TI'.Text},
{'Subscription type': SubType_CBB.Selected.Value},
{'Cost Center': CostCenter_CBB.Selected.'Cost Centre Code'},
{'Network - vnetCidr': vnetCidr_TI.Text})

, "");

Was this reply helpful? Yes No