How to select and edit the record from Gallery using Check Box in Canvas app?

[Arun_Hughes64]

Hi all,

I am building a canvas app. In this case, I added a gallery. I need to select a record from the gallery and need to edit through form, So how can I achieve this?

Thank You.

[Anonymous]

So you have a gallery and you want to edit all entries that the user has selected with the checkbox?

[Arun_Hughes64]

@Anonymous 

Yes, If I check the checkbox and then click the edit button it will navigate to edit form.

Thank You.

[v-yutliu-msft · Accepted solution]

Hi @Arun_Hughes64 ,

Is the check box multiple choice? Since one edit form could only display one item, so if you choose multiple items in the gallery, how do you want to edit multiple records at the same time?

I've figured out some solution that you cold refer.

1)edit multiple record in the same gallery

(In this way, you could choose multiple records, after you click the edit button, you could edit the selected items in the gallery.

But you could only edit the field that you display in the gallery, not all the fields.)

insert a textinput in the galley

set the  textinput's Default:

ThisItem.Title

set the textinput's DisplayMode:

If(Checkbox1.Value&&var,DisplayMode.Edit,DisplayMode.View)

set the check box's oncheck:

Set(var,false)

set the edit button's OnSelect:

Set(var,true)

//Actually, this solution is to change the textinput's displaymode based on the checkbox.

2)if you only select one item in the gallery

then you just need to set the edit button's OnSelect:

Set(selecteditem,LookUp(Gallery1.AllItems,Checkbox1.Value,ID))

set the edit form's Item:

LookUp(fruit11111,ID=selecteditem)

 

 3)if you want to select mutiple records and not only want to edit few fields, then I suggest you edit in another gallery with more controls.

If you insist in using edit forms to edit, the problem is that I can not make sure how many items that you will select, so I can not know insert how many edit forms. (one edit form could only have one item)

set the edit button's Onselect:

ClearCollect(selecteditems,Filter(Gallery1.AllItems,Checkbox1.Value));Navigate(Screen2)

insert another gallery, insert server controls inside the gallery( the fields that you want to edit)

set the gallery's Items:

Filter(table,ID in selecteditems.ID)

set the textinputs' Default:

ThisItem.field1,

ThisItem.field2,.....

set the submit button's OnSelect:

Patch(table,ThisItem,{firld1:TextInput10.Text,field2:Value(TextInput11.Text),.....})

 

Best regards,

[Arun_Hughes64]

Thank you @v-yutliu-msft 

[v-yutliu-msft]

Hi @Arun_Hughes64 ,

Have you solved your problem?

Do you have any other problems?

If you do not have any other problem, could you make my answer as solution?

Thanks!

Best regards,

[Andreykapelist]

Hello. I have filtered gallery. How I can get data to textinput from second record of filtered gallery. Is it select function? 

[Andreykapelist]

Not for edit only data

[Andreykapelist]

I have in filtered gallery for example two records with latitude and longitude. Filtered by date. In one day I have two rows. For creating static map with two points or more I need insert this data to https..... How i can select data from filtered gallery. Thanks

[Andreykapelist]

Result like this