Answered

I need help with update function?

(1) Share

Report

Posted on by samgamer3000

Im trying to update a existing record using htis formula but when I try it it say comment udpated but it remved the comment and I cant see the new updated comment. Im trying to first check that the user who has made comment can only change. The below code is is for submit button of update form. The writebackcomment is the sharepoint list file.

If(

selectedComment.USERNAME = User().FullName,

Patch(

Writebackcomments,

selectedComment,

{

COMMENTS: Inputcpmments.Text,

DATE: Now()

}

);

Notify("Comment updated successfully.", NotificationType.Success);

Navigate(Screen1, ScreenTransition.None),

Notify("You are not the author of this comment.", NotificationType.Error)

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@samgamer3000 -

Your Patch statement will overwrite the existing field with the new value in Inputcpmments (assuming this is a Text Input Control. Is that not what you were expecting?

When you say it "removed" the comment, does that mean the comment field for that record is blank?

What is the reason for using a Patch function here, given you're using an EditForm control? (the EditForm leverages the SubmitForm function).

What does sharepoint list file mean?

Was this reply helpful? Yes No
Verified answer

AndrewR1 1,572 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @samgamer3000

you can try adding a Refresh to the later part of the true statement to refresh your list in the app:

If( selectedComment.USERNAME = User().FullName, Patch( Writebackcomments, selectedComment, { COMMENTS: Inputcpmments.Text, DATE: Now() } ); Notify("Comment updated successfully.", NotificationType.Success); Refresh(Writebackcomments); Navigate(Screen1, ScreenTransition.None), Notify("You are not the author of this comment.", NotificationType.Error) )

What you are doing currently its completely replacing the selected comment with the new text input in the application and this will make changes in the SharePoint lust but this hasn’t yet been refreshed and pullback down to you app.

Hope this helps

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No
samgamer3000 16 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you it solved my problem

Was this reply helpful? Yes No