Answered

Append comment from one screen to another

(0) Share

Report

Posted on by Ram3 Microsoft Employee

Hello, I have 5 screens built into my app.
I have created a comment box in each screen to capture a log for everytime when someone modifies the form. I'm also trying to append all these comments into the comment log in the main screen.
So far, I was able to achieve appending comments from only one screen and I'm struggling to work with all the screens...Has anyone worked on this kind of scenario? Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

If the idea is to consolidate the the comments texboxes into one on main screen the I suggest :
1. Set a variable for each textbox Set(Comment1,Textbox1.Text)
Set(Comment2,Textbox2.Text)

2. On main screen textbox, Concatenate(Comment1," ",comment2)

Was this reply helpful? Yes No
Ram3 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It is a bit complicated than that.
If(Not(IsBlank(RichTextComments.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments.HtmlText & Char(13)) & ThisItem.Comment

I'm using the above formula to concatenate the comments from RichTextComments into html box. Now, the question is I have other richtext comment boxes across other screens and I've to bring them into the main html box. Also, there might not be a necessity for comments in all the screens, there can be a comment in only one of them.

I've used this video if this adds any value.
https://www.youtube.com/watch?v=hzLEecSpmFo

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Ram3 ,

Do you want to combine data from multiple comment boxes in different screens to one main html box?

Actually, you could use data of multiple comment boxes from different screens directly in the main screen.

Just try Concatenate() function.

For example:

set the main html box's HtmlText:

Concatenate(RichTextEditor1.HtmlText,RichTextEditor2.HtmlText,....)

Maybe your data is more complex, you could try:

Concatenate(If(Not(IsBlank(RichTextComments1.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments1.HtmlText & Char(13)) , If(Not(IsBlank(RichTextComments2.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments2.HtmlText & Char(13)) , ...., ThisItem.Comment )

If the solution that I post is not what you want, I suggest you describe with screenshoots in details.

I think I need to know more about what data that you want in the main html textbox.

Best regards,

Was this reply helpful? Yes No