update excel cell to keep the previous data

[mszarka]

Hi,

I am looking for a solution to keep my excel data and update it with the new one and with the date.

like old data: " 01/15/2019 I love chocolate"

user edit : "me too"

new data in the cell: "01/17/2019/ me too 01/15/2019 I love chocolate"

any Idea? I tried collection but I can not insert it to the excel cell.

Thanks

[v-xida-msft · Accepted solution]

Hi @mszarka,

Could you please share a bit more about your scenario?

How do you update your Excel table data? Using Patch function?

Further, could you please share more details about the data structure of your Excel table?

I have made a test on my side, please take a try with the following workaround:

The data structure of Excel table as below:

App's configuration as below:

Within my app, I add a Data Table control to list all records in my Excel table. You could consider add a Data table control to list your Excel table records, when you want to update a specific item, please select it within the Data table.

Set the OnSelect property of the "Patch" button to following:

Patch(
    CommentTable,
    LookUp(CommentTable, Comment_x0020_ID = DataTable1.Selected.Comment_x0020_ID), /* <-- The Comment ID represents the primary column in my Excel table, which could identify one record uniquely*/
    {
       Comment_x0020_Content: Today() & " "&TextInput1.Text& " "& LookUp(CommentTable, Comment_x0020_ID = DataTable1.Selected.Comment_x0020_ID, Comment_x0020_Content)  /* <-- Comment Content column represents the column whose value you want to update */
    }
)

On your side, you should type:

Patch(
    YourExcelTable,
    LookUp(YourExcelTable, PrimaryColumn = DataTable1.Selected.PrimaryColumn), /* <-- Find the specific record you want to update firstly */
    {
       TargetColumn: Today() & " " &TextInput1.Text& " "& LookUp(YourExcelTable, PrimaryColumn = DataTable1.Selected.PrimaryColumn, TargetColumn)
    }
)

Note: The TargetColumn represents the column whose value you want to update within your Excel table. The TextInput1 represents the Text Input control where the user could type his text.

Please check the attached GIF screenshot for more details:

More details about the Patch function in PowerApps, please check the following article:

Patch function

Best regards,

[mszarka]

Hi v-xida-msft,

thank you for the fast reply. I have different table I attached them below. I have tried several times to use Patch unfurtunatelly did not work. I am using and edit field wich conneted to my excel and below the I have just changed the display mode to view. I have a unique Id but is it possible to merge the datas like I mentioned before please to une cell with the old one? And the selection is not working. And also I should not be able to see the table that one is Gallery to DetailScreen to Edit and I do not wnat ot show table dat only plain text

1

Many thanks