Answered

powerapp triggered flow

(0) Share

Report

Posted on by tylacha

Hi,

I am following the tutorial here for an appended comment solution: https://www.c-sharpcorner.com/article/display-appended-comments-version-history-from-sharepoint-list-on-powerapps/

I am running into an issue where I am getting null values in my comments from when I update my form without entering notes. How can I filter these out?

Also, side question... I have two screens for my form. Edit and View. Can a button not be clickable in view mode? I can't seem to get it to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

what is the control type displaying those comments, and what does its items or text property contain code wise.

If it is a gallery, could you also share what the source column containing the comments looks like

Was this reply helpful? Yes No
tylacha 36 on at

Like
a
(0)

Report
Copy link

Link copied!
I added a link to the tutorial in my original post, the comments are retreived from an HTTP request, then parsed with json, finally combined with concat to a single variable in an apply for each . I'm very new to powerapps, so hopefully I am explaining properly. Here is the snipet from the tutorial where everything is coming together.

Add an action to “Parse JSON”.

Add Content, select Body as result there. We need to parse a comment from the value. So, we will add the following thing as schema.

{
    "type": "object",
    "properties": {
        "value": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "Comment": {
                        "type": "string"
                    }
                }
            }
        }
    }
}
Click an action “Compose” so that “Apply to each” will be created automatically.

In Compose, create the below formula.

formatdatetime(items('Apply_to_each')['Modified'],'MM/dd/yyyy hh:mm tt')
Now, add an action “Append to string variable”.

In name, select the already created variable named “AppendComment”.

concat('<div style="margin-bottom:5px;">',items('Apply_to_each')['Author']
['LookupValue'],' (<span style="color: rgb(3, 131,
135)">',outputs('Compose'),'</span>)',': ',items('Apply_to_each')
[variables('ColumnName')],'</div>')

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

add a conditional loop in your forall to check if the item is null or not before appending your comment.

Was this reply helpful? Yes No