Model driven command bar - update all records selected

(1) Share

Report

Posted on by ProFe

Hi everyone,

I have a subrid with records. I want to select records, and press a button so the records are updated.

This is my code:

Patch('Training Subscriptions';

ForAll(Self.Selected.AllItems;

{

TriggerFlowResult:true;

Result:true}

))

But when I press my button, my records are duplicated instead of updated.

I tried lot of things, but nothing worked, ie : open & refresh component library, inverse Patch & ForAll places...

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

SBax 1,348 on at

Like (0)

Report
Copy link

Link copied!

You don't need the for all, as self.selected.items is a collection

Try

Patch('

Training Subscriptions',

Self.Selected.AllItems,

{

TriggerFlowResult:true;

Result:true

}

)

Was this reply helpful? Yes No
ProFe on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer, but when I try this I encounter an error
This is due to .AllItems, I tried Self.Selected.Item but in this case I only patch the first selected record.

Was this reply helpful? Yes No
Verified answer

Jonathan Manrique 2,695 on at

Like (1)

Report
Copy link

Link copied!

Hi @ProFe

The issue is that you are telling it to make a patch of elements and if you don't tell it which one the default one is creating,
The first thing you should do is go through each element to make the patch and you can do this using the lookup function and that way you will be telling it that that element is going to be updated.
If memory serves it would be Patch(tables,ForAll(elements;lookup,{
TriggerFlowResult:true;
Result:true}
))
If not the other way around first ForAll(Patch(Lookup

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
ProFe on at

Like (0)

Report
Copy link

Link copied!

Great, I get it now.
I managed to make it work with this formula :

Patch('Training Subscriptions';ForAll(Self.Selected.AllItems;
{
'Training Subscription': ThisRecord.'Training Subscription'; // this line was missing
TriggerFlowResult:true;
Result:true
}
))

Thank you all for your help !

Was this reply helpful? Yes No