Answered

HTML label is not rendered quick enough

(0) Share

Report

Posted on by Krau5i

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

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That's an HTML text control. What's its HtmlText property set to?
Krau5i 45 on at

Like
a
(0)

Report
Copy link

Link copied!
This is the 'code':
"<center>You have " & CountIf( AP_Data, Requisitioner_x0020_Email = User().Email, Processed = "No" ) & " item(s) in AP and " & CountIf( TE_Data, 'Exp Line Created by Name' = Mid( User().FullName, Find( " ", User().FullName ) + 1 ) & ", " & Left( User().FullName, Find( " ", User().FullName ) - 1 ), Processed = "No" ) & " item(s) in T&E to validate.</center>"
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Try this maybe?
"<center>You have " & IsBlank(CountIf( AP_Data, Requisitioner_x0020_Email = User().Email, Processed = "No" ),0) & " item(s) in AP and " & 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) & " item(s) in T&E to validate.</center>"
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
Krau5i 45 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not sure why by I get an 'invalid number of arguments' error. 2 received, 1 expected
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Oops, try this
"<center>You have " & If(IsBlank(CountIf( AP_Data, Requisitioner_x0020_Email = User().Email, Processed = "No" )),0) & " item(s) in AP and " & 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) & " item(s) in T&E to validate.</center>"
Krau5i 45 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Krau5i 45 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 HTML text here."
Krau5i 45 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked perfectly. Thanks!