patching checkbox selected items

(0) Share

Report

Posted on by elseb

774 Moderator

I have a massive brainfart and can't figure this out, the best result was patching some empty rows...

I would like to patch one column in the records of items selected in the gallery (using the checkbox), the value to patch would come from the dropdown.

ForAll(Filter(Gallery1.AllItems, Checkbox1.Value=true),
Patch('Assets',
{asset_location: DDmoveto.SelectedText};
);
)

i'm sure it's something silly but my brain refuses to cooperate today...

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MF-12051538-0 402 on at

Like (0)

Report
Copy link

Link copied!

Hi @elseb ,

You don't need "=true", as Checkbox1.Value by itself will return true or false. Also, try explicitly selecting the field name from your drop down.

e.g.

ForAll(
Filter(Gallery1.AllItems, Checkbox1.Value),
Patch(
Assets,
{asset_location: DDmoveto.Selected.ColumnName}
)
);

If you found this post helpful, please consider Accepting it as the solution.

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thank you, i think I haven’t explained it well enough and my code being so far off it didn’t help either…
what I’m trying to do is

Patch(
             Assets,
             LookUp(Assets, asset_number = Gallery1.Selected.asset_number),
        {asset_location: DDmoveto.Selected};
)

but for all the items selected in gallery using checkbox control

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @elseb,

You should post the specific error message corresponding to the formula.

Could you please tell me that

1). what is the column type of the asset_location, is it a Choice type?

2). how you set the Items property of the DDmoveto?

Generally, if the asset_location is a choice column, and you set the DDmoveto using the Choices() function, you should modify your formula as below:

Patch( Assets, LookUp(Assets, asset_number = Gallery1.Selected.asset_number), {asset_location: {Value:DDmoveto.Selected.Value}} )

Was this reply helpful? Yes No
Verified answer

elseb 774 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi,

I've managed to do it with:
ForAll( RenameColumns( Filter( colAssets, isChecked ), "ID", "TID" ), Patch( 'Assets', LookUp( 'Assets', ID = TID ), {asset_location: DDmoveto.SelectedText} ) );

Was this reply helpful? Yes No