I have a power app application that contains a gallery that is linked to a sharepoint list. I have created a collection from the gallery that is modified in various ways and as a result I need to upload the data from the collection back into the sharepoint list to an already created records (by ID). I figured this out with this code:
Onselect property of button:
Patch('SharepointlistName', ForAll(collectionName As _item,{ID: _item.ID, Column: _item.Column}))
But what I also need (and I don't know if this is possible) is that the value (Column) , which is sent from the collection, does not overwrite the value that is already in the cell in sharepoint list for the right item, but just adds another value that would be separated by ;
Like this:
For item 1 (which is already created in sharepoint list) value = 5 is sent from power apps
In sharepoint list should look like this: 5;
For item 2 (which is already created in sharepoint list) value = 1 is sent from power apps
In sharepoint list should look like this: 1;
Sharepoint list:
| Title | Column |
| Item 1 | 5; |
| Item 2 | 1; |
then the next modification takes place in powerapps:
For item 1 (which is already created in sharepoint list) value = 2 is sent from power apps
In sharepoint list should look like this: 5;2;
For item 2 (which is already created in sharepoint list) value = 3 is sent from power apps
In sharepoint list should look like this: 1;3;
Sharepoint list:
| Title | Column |
| Item 1 | 5;2; |
| Item 2 | 1;3; |
and on and on...
Can I ask for advice?
Thank you
