Power Platform Community Forum Thread Details

Hello there, I have the following problem: I would be super excited if you could help me out.

I have a form that is connected to my Excel file with the columns ID and comment.

The form contains a datacard "comment," which I want to change in the app itself. Depending on the variable varID, I first want to filter the right row, if that makes sense.

The form has the data source set to my excel file and the item setting to LookUp(myexelfiletable; ID = varID; ThisRecord).

I have a Save button that saves the new comment to my Excel file:

Patch(myexcelfiletable; LookUp(myexcelfiletable; ID = varID); {Comment: DataCardValue.Text});

Refresh(myexceltable);;

Now I'm confused on what the setting should be so that whenever I change the text of the datacard, it is saved to the excel file and stays that way.

I tried setting the datacard value to default = ThisItem.Comment, but whenever I change the comment, it is correctly saved to the excel file, but after a short period of time, the datacard value resets to its original value.

Say the original comment was: Comment 0.

I change the comment to CommentChange and press the save button. The excel file will show the newly updated comment in the correct column and row, but in the app itself, after 2 seconds, Comment0 is shown again.

I hope the question is formulated reasonably. Feel free to ask questions.