Answered

Patch a all items from a gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a gallery, where items one ordered is placed. All of the items should then be saved to the user which is selected in the dropdown. But how to I patch all the items into the same column to the selected person?

The Strandard laptop ny and Screen 27" should end in the same row in that column under that person.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
You must reference the gallery's fieldname in the 3rd argument of PATCH rather than Gallery3.AllItems.

ForAll(Gallery3.Items, Patch( Items, LookUp('Overview Hardware', 'Name {Name})' = Dropdown.Selected.Value), {test: galleryfieldname} ) )

Next time please provide the text from your code. It takes alot of effort to rewrite everything.

---
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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@mdevaney it does not work :S

ClearCollect(Items,LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value, ThisRecord)); ForAll(Gallery3.Items, Patch( Items, LookUp('Overview Hardware', 'Name {Name})' = Dropdown.Selected.Value), {test: Gallery3.Title4} ) )

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
This section of the code is wrong:

{test: Gallery3.Title4}

Is Title4 a label? If yes, please tell me what code is inside the Text property of the label. The fieldname inside the text property should replace Gallery3.Title4

---
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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@mdevaney Yes it is a label and is given

ThisItem.HardwareType

But putting that into the code does not work either.

ClearCollect(Items,LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value, ThisRecord)); ForAll(Gallery3.Items, Patch( Items, LookUp('Overview Hardware', 'Name {Name})' = Dropdown.Selected.Value), {test: Hardwaretype} ) )

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
It appears there is a problem with this code. I have no idea what it refers to but this is what needs fixing.

'Name ({Name})'

---
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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@mdevaney I fixed it but the problem is that it is only patching the first item in the gallery and not all of them,.

ClearCollect(Items,LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value, ThisRecord)); ForAll(Gallery3.AllItems, Patch( Items, LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value, {test: HardwareType} ) ))

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
It looks like one of your brackets is missing

ClearCollect(Items, LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value, ThisRecord));

ForAll(Gallery3.AllItems,
Patch(
Items,
LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value),
{test: HardwareType}
)
)

Also, a typical reason for only patching the 1st record is the criteria column in the LOOKUP function is not a unique value.

---
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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@mdevaney. There was missing a bracket..

It still only patch the first item? How can I patch the whole gallery into that row, do you know? 🙂

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Solved it with
ClearCollect(Items, LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value, ThisRecord)); Patch( 'Overview Hardware', LookUp('Overview Hardware', 'Name ({Name})' = Dropdown1.SelectedText.Value), {HardwareTypeGiven:Concat( Gallery3.AllItems,Title4.Text, ",") } )

Was this reply helpful? Yes No