Gallery Items- Insert , Update , Delete ( Sharepoint List )

[avi2017]

Hi Gurus

I have a gallery where user can Insert , Update and Delete an Item . 

When user hits save button all rows in the Gallery to be saved back to sharepoint list ( If it is an insert on the gallery using + button  insert a new line in sharepoint list , If deleted delete that line from sharepoint list , If updated , update that line in sharepoint list ) . 

How to achieve this requirement.

Details on the screen attached .

[v-bofeng-msft]

Hi @avi2017 :

Could you tell me:

• What is the gallary's item property?What is the relationship between this collection and the SharePoint List?
• Do you want to edit/add/delete the corresponding records in the SharPoint List when editing this collection in the gallery?

Sorry, I am confused about your question. If you can provide more details, I may be able to provide more specific soltuion.

I'v made a test for your reference:

1\ My SharePoint list-LIST6

2\ Set app’s OnStart property to:

ClearCollect(AAA,LIST6)  // AAA is my test collection ,LIST6 is my sharepoint list

3\ Add a blank gallery control ‘gallery1’ to screen1 and set its Items property to:

AAA

4\ Insert four textinput controls into ‘gallery1’  (TextInput3/TextInput3_1/TextInput3_2/TextInput3_3)

TextInput3-Default 

ThisItem.Title

Onchange

Patch(AAA,ThisItem,{Title:TextInput3.Text});Patch(LIST6,LookUp(LIST6,ID=ThisItem.ID),{Title:TextInput3.Text})

TextInput3_1-Default 

ThisItem.NAME

OnChange

Patch(AAA,ThisItem,{NAME:TextInput3_1.Text});Patch(LIST6,LookUp(LIST6,ID=ThisItem.ID),{NAME:TextInput3_1.Text})

TextInput3_2-Default 

ThisItem.INTEREST

OnChange

Patch(AAA,ThisItem,{INTEREST:TextInput3_2.Text});Patch(LIST6,LookUp(LIST6,ID=ThisItem.ID),{INTEREST:TextInput3_2.Text})

TextInput3_3-Default 

ThisItem.BONUSAMOUNT

Onchange

Patch(AAA,ThisItem,{BONUSAMOUNT:TextInput3_3.Text});Patch(LIST6,LookUp(LIST6,ID=ThisItem.ID),{BONUSAMOUNT:TextInput3_3.Text})

6\ Add a Add Icon control to screen1 and set its onselect property to:

Patch(LIST6,Defaults(LIST6),{Title:Blank(),NAME:Blank(),INTEREST:Blank(),BONUSAMOUNT:Blank()});
Patch(AAA,Defaults(AAA),Last(Sort(LIST6,Modified,Ascending))

7\ Insert trash Icon control into ‘gallery1’ and set its onselect property to:

Remove(AAA,ThisItem);Remove(LIST6,LookUp(LIST6,ID=ThisItem.ID))

9\ The result are as follow:

 

No need to submit changes, all changes in the gallery will be immediately submitted to the SharePoint list.

Best Regards,

Bof

[avi2017]

@v-bofeng-msft 

Thanks a lot for the reply. Part of my requirement works with the logic mentioned in your reply . Most of the times my need is to copy all employees from existing company code and add/delete/modify copied employees and save those employees in new company code

For example in LIST6 max value of company code is 80000000002 , then i add 1 to 80000000002 and next company code is 80000000003

When i select company code 8000000002 in the drop down list . All employees from company code 8000000002 will show up in Gallery where insert/delete/modify employes and when SAVE button is pressed or on action those employees in the Gallery should save into COLLECTION and finally into LIST6

Below mentioned is how LIST6 is 

so when company code 80000000002 is selected below employees will be visible in Gallery 

I can insert/modify/delete employees from the Gallery but when it gets saved to COLLECTION or LIST6 it should consider those as new entries to LIST6 with COMPANY CODE 800000000003  and after save LIST6 should look like as below

Company Code	EMPLOYEEE#	NAME	INTEREST	BONUS AMOUNT
80000000000	200000	XYZ1	20	100
80000000000	200001	XYZ2	21	200
80000000000	200002	XYZ3	22	300
80000000000	200003	XYZ4	23	400
80000000000	200004	XYZ5	24	500
80000000000	200005	XYZ6	25	600
80000000000	200006	XYZ7	26	700
80000000001	200009	PQR	10	350
80000000002	200010	EDG	2	145
80000000002	200011	TSE	12	234
80000000003	200010	EDG	2	145
80000000003	200011	TSE	12	234
80000000003	200013	TSE	12	234

Thanks 

[v-bofeng-msft]

Hi @avi2017 :

Has the problem been solved?
Is there anything else I can help?

In addition,Since the ‘company code’ is a field in the data source, I think there is no need to use collection. I suggest you directly set the gallery's items property to:

Filter(LIST6,'Company Code'=YourDropdown.seleceted.'Company Code')

Best Regards,

Bof