Hi Community,
I have a gallery connected to an Excel spreadsheet stored in SharePoint. Using text input, I filter the data in a column called ID to view data for: Name, Code, and Total. I also inserted a dropbox into the gallery to select "yes" and "no."
The gallery is made up of four labels: Label 1 shows the ID, Label 2 shows the Name, Label 3 shows the code, Label 4 shows the Total, and the dropbox allows you to select "yes" or "no."
This is how it looks, for example, when I select ID 1 and ID 4. Depending on the ID, 1, 2, 3, 4 or 5 records (data rows) are displayed.
Is it possible to load the information shown in the table into a Sharppoint list using the Patch function associated with a button?.
I have my list with the Title column to enter the ID, and another column with the comments name to concatenate and enter the rest of the data, but since only the data from the last row is being recorded. This is what I see in the sharepoint column for ID1: NO T43E 3456GGG 31, and I need to see: YES A345F FFGSFDG 10/YES S34G SDDFGG 5/YES 1DD3 SFDDGG 2/ NO T43E 3456GG 31.
Patch(
'NameShpList';
Defaults('NameShpList');
{
Title:'Label1'.Text;
'Comments': Concatenate("Received": 'Dropbox'.SelectedText.Value;" ";" ";'Label2'.Text;" ";'Label3'.Text;" ";'Label4'.Text
})
