cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

HTML label is not rendered quick enough

 
 

Hi All,

 

every user of my app sees attached message on the welcome screen. It gives the App an unprofessional feel. I'm assuming the reason is that the label contains a CountIf formula that counts items from a Sharepoint list. Is there any chance to delay the visibility of the label?

 

Thanks,

Tobias 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

I feel like I'm overthinking this. I'm going to try to think on it. In the meantime, you can try setting the HTML text box's Visible property to this:

HtmlText1.HtmlText <> "Show your <b><font color=blue>HTML</font></b> text here."

View solution in original post

10 REPLIES 10
Highlighted
Super User
Super User

That's an HTML text control. What's its HtmlText property set to?

Highlighted

This is the 'code':

"<center>You have <b>" & CountIf(
    AP_Data,
    Requisitioner_x0020_Email = User().Email,
    Processed = "No"
) & "</b> 
item(s) in AP and <b>" & CountIf(
    TE_Data,
    'Exp Line Created by Name' = Mid(
        User().FullName,
        Find(
            " ",
            User().FullName
        ) + 1
    ) & ", " & Left(
        User().FullName,
        Find(
            " ",
            User().FullName
        ) - 1
    ),
    Processed = "No"
) & "</b> item(s) in T&E to validate.</center>"

 

Highlighted

Try this maybe?

"<center>You have <b>" & IsBlank(CountIf(
    AP_Data,
    Requisitioner_x0020_Email = User().Email,
    Processed = "No"
),0) & "</b> 
item(s) in AP and <b>" & IsBlank(CountIf(
    TE_Data,
    'Exp Line Created by Name' = Mid(
        User().FullName,
        Find(
            " ",
            User().FullName
        ) + 1
    ) & ", " & Left(
        User().FullName,
        Find(
            " ",
            User().FullName
        ) - 1
    ),
    Processed = "No"
),0) & "</b> item(s) in T&E to validate.</center>"

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Highlighted

I'm not sure why by I get an 'invalid number of arguments' error. 2 received, 1 expected

Highlighted

Oops, try this

"<center>You have <b>" & If(IsBlank(CountIf(
    AP_Data,
    Requisitioner_x0020_Email = User().Email,
    Processed = "No"
)),0) & "</b> 
item(s) in AP and <b>" & If(IsBlank(CountIf(
    TE_Data,
    'Exp Line Created by Name' = Mid(
        User().FullName,
        Find(
            " ",
            User().FullName
        ) + 1
    ) & ", " & Left(
        User().FullName,
        Find(
            " ",
            User().FullName
        ) - 1
    ),
    Processed = "No"
)),0) & "</b> item(s) in T&E to validate.</center>"
Highlighted

No, now the counters don't work (are not shown in the text anymore)... Do you know what the reason for that behavior is? Maybe I should have made this clear earlier: The formula does work perfectly, however, it takes a few seconds for the label to show up. Until then, "Show your HTML text here." is shown which I would like to get rid of.

 

Regards,

Tobias 

Highlighted

Oh! Gotcha. In that case, you have a couple options. The first would be to load those data sets on your App's OnStart property so that they're loaded in before the user sees anything, or you can try setting the HtmlText box Visible property to this:

Not(IsBlank(HtmlText1.HtmlText))

Not sure why it's showing that default HTML text when that's not your HtmlText property value.

Anyway, if one of those options don't work let me know.

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Highlighted

Hm what exactly would you include in the OnStart property? My concern is that this CountIf formula will be updated during the use of the app. I tried to set the visible property to your suggestion but it did not change the app's behavior. 

Highlighted

I feel like I'm overthinking this. I'm going to try to think on it. In the meantime, you can try setting the HTML text box's Visible property to this:

HtmlText1.HtmlText <> "Show your <b><font color=blue>HTML</font></b> text here."

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,658)