cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Krau5i
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
EricLott
Resident Rockstar
Resident Rockstar

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
EricLott
Resident Rockstar
Resident Rockstar

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

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>"

 

EricLott
Resident Rockstar
Resident Rockstar

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.

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

EricLott
Resident Rockstar
Resident Rockstar

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>"

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 

EricLott
Resident Rockstar
Resident Rockstar

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.

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. 

EricLott
Resident Rockstar
Resident Rockstar

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,783)