Patch function - comment is adding to a new line in excel except of existing record.

(0) Share

Report

Posted on by MP-13011217-0

158

Hello All,

I have an excel file as a data source and I am trying to update record by adding comment to it using patch function. When I choose a record from my gallery and press icon to show input comment box it appears. Then I am writing something and press another icon "tick". It should add this to an existing record but instead it is adding a new line to my excel file with my comment. How do I fix that, please? I guess I need to add something to my patch code...:

Patch( Table10, {Comment: TextInput2.Text })

Comment in my command is an empty column and where You see yellow line on screenshot - this is ThisItem.Comment.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

VeGETzX 367 on at

Like (1)

Report
Copy link

Link copied!
Seem like your code missing the part that tell which record need to be patched,
Try this:

Patch(Table10, Gallery.Selected, {Comment: TextInput2.Text})

You will need to replace Gallery with the name of your gallery.

Hope this help!

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Thank You so much! I was trying to do it more complicated way and simple solutions are always best 😄 thanks again!

Was this reply helpful? Yes No