I am trying to create a component which act like a SharePoint "append to text" multiline text field. I have built the component with a textbox to enter the text and then once saved the entry goes into a gallery below. Here is a screenshot to give further context:
So I have created a custom property called "NotesDataSource" which is a date type of Table and this will be added to the Gallery's, Items property to retrieve historic notes from a data source. I have created the following table structure with dummy data so that the gallery knows what values to set to each control in the gallery:
Table(
{Note: "this is note number one", NoteCreatedBy: "Suresh Memmi", NoteCreatedDate: "09/03/2021"},
{Note: "this is note number two", NoteCreatedBy: "Suresh Memmi", NoteCreatedDate: "18/09/2022"}
)
When I add this component to a canvas screen I set the "NotesDataSource" property to a Dataverse table called "Meta notes", which also has the columns "Note", "NoteCreatedBy", "NoteCreatedDate" but it also has many other columns. I need to assign these specific columns to the specific column values of the "NotesDataSource" Table structure. I have tried setting the following to "NotesDataSource":
ShowColumns('Meta notes', "Note", "NoteCreatedBy", "NoteCreatedDate")
However even with the same colum names the component does not know which Dataverse columns to assign to the "NotesDataSource" table structure . I can't use "Thisitem" either as the gallery is part of a component.
I hope I've explained the problem clearly and I'm stuck at how to achieve this, any ideas?