Update SharePoint column from selected item in gallery

(0) Share

Report

Posted on by JimmyW

2,567

Hi im trying to update a specific column named "Comments" in a SharePoint list.

I have a gallery that displays the items in this list (Gallery1)

I then have a Input RichText field.

I would like to patch/update comments for the select item in gallery1 with whatever i type in the RichText field.

Im not able to get this to work, i tried patch and i tried submit form.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @JimmyWork

Can you try to update the configuration as:

Patch(DataSourceName, LookUp(DataSourceName, ColumnName = Gallery1.Selected.ColumnName), {Comments: PlainText(RichTextEditor2.HtmlText)})

This will store the data entered in Rich Text control to the selected item in gallery. Here, ColumnName needs to be replaced with the name of the column to uniquely identify the record.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255 Thank you for answering.
I tested you solution and it works, i do get a delegation warning.. Only issue i have is that it overwrites all current comments so i just simply want to add more but not replace.

Patch(DataSource, LookUp(DataSource, 'Case Comments' = Gallery1.Selected.'Case Comments'), {'Case Comments': ""&User().FullName&"" & " "& Now()&" " & RichTextEditor2.HtmlText & Char(13)) & Gallery1.Selected.'Case Comments')})

What im trying to achive is that it will add new comments and keep the old. Also when adding a new comment it should add the html text containg the user fullname and current time and date.
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255

This seems to work without delegation warning. But my issue now is that the text is put last i want it on top. So when i write a comment the latest comment should be on top, right now it becomes the last.

Patch(DataSource,
Gallery1.Selected,
{'Case Comments':Gallery1.Selected.'Case Comments' & "" &
Char(13) & Char(13) & User().FullName & "" & " "& Now()&" " &
Char(13) & RichTextEditor2

}
);
Reset(RichTextEditor2)
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255 Added a image to explain what i mean.
When i patch a new comment i want it to be displayed 1st. Currently it's displayed like this. I Would like the latest comment to be displayed on top.
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JimmyWork ,

To display items from SharePoint list with latest item on top, you can use below formula in the Items property of the gallery control:

SortByColumns( DataSourceName, ID ,Descending)

Regards,

Mona