Bulk record updation

(0) Share

Report

Posted on by Powerappsuser11

237

Hi,

I got below error while patch bulk records.

Please help to resolve the issue.

Onselect of submit button my code is

UpdateIf(Rowsave,true,
{
Status:{Value:"Submitted"}

});
Patch('Time sheet',Rowsave);
Notify("Records Submitted",NotificationType.Success);
Clear(Rowsave)

Categories:

Building Power Apps

All responses (12)

Answers (0)

Sort by

Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Powerappsuser11,

Your patch function is missing the third argument that is the data to patch on the current record. Also the second argument to patch function should be a record not a table. It would be something like this.

Patch('Time sheet',Rowsave, {Status: "Submitted"});

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If this does not help can you please explain what you are trying to achieve.
Powerappsuser11 237 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Talha_Dar

Thanks for respond,

In screen added blank gallery ,Gallery items=colletions---Add row
In gallery added checkbox,draft button.
My requirement is bulk update draft records.
checkbox--oncheck---collect(rowsave,thisitem)
onuncheck---Remove(rowsave,thisitem)
Onselect of submit button my code is
UpdateIf(Rowsave,true,
{
Status:{Value:"Submitted"}
});
Patch('Time sheet',Rowsave);
Notify("Records are submitted",NotificationType.Success);
Clear(Rowsave)
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you want to patch your list with the data in "RowSave" collection?
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Powerappsuser11,

Here is how you can achieve the desired functionality.
Set the following formula on the "OnCheck" and "OnUnCheck" property of Check Box.

ClearCollect(Rowsave, Filter(GalleryName.AllItem, CheckBoxName.Value = true)

Then on the submit button Set the following code.

ForAll(Rowsave As currItem, Patch('Time sheet',currItem, {Status: "Submitted", // Other patch data});) Notify("Records are submitted",NotificationType.Success); Clear(Rowsave)

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Powerappsuser11 237 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Talha_Dar

I tried above code but getting below error.
Please help to resolve this one.
checbox-oncheck-ClearCollect(rowsave,Filter('Add Gallery'.AllItems,Checkbox8.Value=true))
unoncheck-ClearCollect(rowsave,Filter('Add Gallery'.AllItems,Checkbox8.Value=true))
Submit button-onselect
ForAll(rowsave,Patch('Time sheet',rowsave,
{
status:"Submitted"
}));
Notify("Records are submitted",NotificationType.Success)
Clear(rowsave)
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I provided you with this formula, but you are using a modified one.

ForAll(Rowsave As currItem, Patch('Time sheet',currItem, {Status: "Submitted", // Other patch data});)

Here "Rowsave" is you collection name and 'Time sheet' is your Datasource name you can change these two with your own variables.
Powerappsuser11 237 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Talha_Dar
I tried but getting error.
My code on select of submit button.
ForAll(indata,Patch('Time sheet',indata,
{
status:"Submitted"
}));
Notify("Records are submitted",NotificationType.Success)
Clear(indata)
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You are not using the correct formula. What is the name of your collection?
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

is "indata" your collection name?