Repeating Table on Edit Mode

[Anonymous]

Hi,

Currently, I am building a Form in Edit Mode and I am lost.

I want to let the user edit their records in the SharePoint List

In edit Mode for update:

-          User can remove the data that the user doesn’t want

-          User can add a new row to insert a new data

-          User can edit the existing data

After the update:

-          The system able to save and update ONLY the updated data (data that was edited, data that was added, data that was removed)

-          The system able to update to the SharePoint List

As now, I created a new screen which put a gallery in it where the data source is (‘People that has access ’) and I filter based on the tracking ID.

As now, I created a new screen which put a gallery in it where the data source is (‘People that has access ’) and I filter based on the tracking ID.

Based on the image above:

1)      Save button: update all the modification that has been done in the repeating table

2)      “+” icon: allows user to add rows

3)      Pencil icon: allows user to edit rows

I tried the Patch() at the Save button but is not working

I tried the Collect() at the “+” but it did not add another row.

Is there any way to do so?

I really need some help on this edit mode.

Thank you

[v-yutliu-msft]

Hi @Anonymous ,

Do you want to make you "save" and "+" button works?

Could you tell me:

1)do you only want to update user field and 'scope of access' field?

2)the data type of user field and 'scope of access' field?

3)what controls do you use to update user field and 'scope of access' field? two textinputs?

I assume that 1)yes, 2)both text type, 3) two textinputs

If so, try this:

1)save button's OnSelect:

Patch('People that has access to data',
       LookUp('People that has access to data',TrackingID=DataCardValue2.Text),
       {user :usertextinput.Text,'Scope of Access':scopetextinput.Text}
) 

2)+ button's OnSelect:

Patch('People that has access to data',
       Defaults('People that has access to data'),
       {user :usertextinput.Text,'Scope of Access':scopetextinput.Text}
) 

Best regards,

[Anonymous]

Hi @v-yutliu-msft,

Thank you for your reply,

I tried your formula but it does not show out in the repeating table instead it showed the item has been created on the SharePoint list.

As now, I wanted to add a record in the repeating table and show me the Save Icon and Remove Icon. After that, the user can click on the Save icon to save the records.  I have "Pencil" to edit the item

This is the formula on the "+" icon

When I clicked on "+", it only shows out on the SharePoint List 

Why is that?

Is there any way to solve?

Thank you