Currently i have an issue.
I have a gallery that i uses a collection i made from a SharePoint list, I use a filter when i create this collection.
ClearCollect(RecordsTickets, Filter(SharePointList, RequesterEmail = varUser && Status.Value="Closed"))
On the item on the gallery i use OnSelect = and i set multiple variables for the item and then navigates to screen2
Now to the issue i have.
I use Patch on Screen2 where i save a comment to a SharePoint column.
When i type something and click save what i have written should be displayed instantly meaning the variable for the item should be update. Now the only way that i found to do this is by doing a new ClearCollect using the exact same filter from that was used on Screen1 so it matches the item to update. And i have to do this twice and refresh at the same time to make it work. I'm pretty sure I'm doing this all wrong
If(
!IsBlank(RichTextEditorComment_1.HtmlText),
Patch(
SharePointList,
varSelectedTicket,
{
'Case Comments': "<b>" &
Char(13) & Char(13) & User().FullName & "</b>" & "<br> <span style='font-size:12pt'>"& Text( Now(), "[$-en-US]yyyy/mm/dd hh:mm")&"</span> <br> " &
Char(13) & RichTextEditorComment_1.HtmlText & varSelectedTicket.'Case Comments'
}
)
);
Reset(RichTextEditorComment_1);
Refresh(SharePointList);
ClearCollect(RecordsTickets, Filter(SharePointList, RequesterEmail = varUser && Status.Value="Closed"))
Set(varSelectedTicket, Gallery1_1.Selected);
Refresh(SharePointList);
Set(varSelectedTicket, Gallery1_1.Selected);
