Unanswered

Viewing Messages in a Gallery

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have a gallery that shows items raised in a sharepoint list, on the arrow on the gallery I have

Set(varRecord, ThisItem)

I then have a rich text editor box so that new comments can be entered and patched to an item in the sharepoint list via a button, the button's code is

Set(
	varRecord,
	Patch(
		CustomerServices,
		varRecord,
		{Messages: varRecord.Messages & "***" & CountRows('Messages Gallery'.AllItems) + 1 & " - " & User().FullName & " - " & Now() &
":<br>" & RichTextEditor1.HtmlText}
	)
);
Reset(RichTextEditor1)

I then have another gallery which I'd like to be able to see all of the previous messages that have been put on the select item from the first gallery, I assumed the code should be the below but it's telling me there's an error

Filter( Split(varRecord.Messages, "***"), !IsBlank(Result))

I've put a HtmlText input inside the 2nd gallery and entered the below in HtmlText but again getting an error, can you advise where i'm going wrong please?

ThisItem.Result

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

janson 62 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the error you are getting? Is Messages a text column in the CustomerServices list? Btw, do you really need to use the global variable varRecord? Can't you just refer the record directly?

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @janson
Yes Messages is a multiline text column in the sharepoint list.

The errors i'm getting on the Items for Messages Gallery are "the function IsBlank has some invalid arguments" and "Name isn't valid, 'Result' isn't recognized

And the errors i'm getting on the HTMLText of the HtmlText input are "Name isn't valid, 'Result' isn't recognized.

The reason for using the variable varRecord is because I wanted to group all of the messages together but be able to display them as individual results in the last gallery so that you can expand them individually. I used the below video for reference from 6minutes and 15seconds in as that's exactly what i'm looking to achieve but just doesn't work for me
https://www.youtube.com/watch?v=dre1E9GiDJM

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

Split() returns a single column table with Value as the name of the column, not Result. !IsBlank() should not be used in Filter() as it doesn't delegate. Further, I'm not getting valid results in testing with <> Blank(), but "" seems to work fine. Therefore, the solution is to change Result to Value and replace !IsBlank() with <> "":

Filter( Split(varRecord.Messages, "***"), Value <> "")

Example from my testing:

@janson makes a good point: Consider using gallery.selected instead of assigning that record to a variable. So instead of this code for the Arrow.OnSelect: Set(varRecord, ThisItem), change that to:

Select(Parent)

And then any code that follows this selection made by the user can simply use gallery.selected. In most scenarios, this eliminates the need for a global variable.

Hope this helps!

Aaron

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AaronKnox

Thank you for this and the level of detail. That has resolved the first error but I still have the error on the HtmlText input box within the second gallery to show the previous messages (where you have it split as testing1 - testing6), what formula do I need to use for that box please?

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

Does this formula work?

ThisItem.Value

Without knowing the 2ndGallery.Items property, I can only guess.

Thanks,

Aaron

Was this reply helpful? Yes No