copy data entered in one row of gallery to another rows of gallery

[ridhan]

Hi All,

I have a requirement in which gallery has 10 fixed row. These rows have ID- 1to 10. gallery consist of text inputs, dropdown and combobox. There will one copy icon and paste icon in each row. So if user has entered any value in any row example in 5th row then he can click on copy icon of that row and can click on paste icon of anyother. So that copied data will only be pasted in that selected row. 

Items of gallery-

gallery pic-

[scalca · Accepted solution]

basically you need something to store the copied values and update the selected record in the collection, therefore you're collection must have all the columns too in order to keep those values.
for example if I have a gallery with one textinput and one dropdown I would initialize it like this

ClearCollect(ItemsCollection, {ID: 1, Text: "", Choice: {Value:""}}, {ID: 2,Text: "", Choice:{Value:""}},{ID: 3,Text: "", Choice: {Value:""}},{ID: 4,Text: "", Choice: {Value:""}})

value property of textinput control: ThisItem.Text

DefaultSelectedItems property of dropdown control: ThisItem.Choice

the onselect of the copy icon is going to store the current values in a variable like this

Set(varCopied, {Text: TextInputCanvas1.Value, Choice: DropdownCanvas3.Selected})

finally the onselect of my paste icon would patch varCopied values to corresponding record in my collection like:

Patch(ItemsCollection, LookUp(ItemsCollection, ID = ThisItem.ID) , {Text: varCopied.Text, Choice: varCopied.Choice})

here it's also possible to use UpdateIf function without using the lookup

hope this helps

[Jmanriquerios]

Hi @ridhan 

In your paste button you must make a patch to your gallery to which you want to copy, making a mapping between the data

Patch(table, default(),{item:galleryselect.name})

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

[ridhan]

Hi @scalca - It works for me. Thanks for your help.

Regadrs!