cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gabe_RookieDev
New Member

Error at refreshing a form display

Hello, I hope everyone is healthy and safe.

First of all, my apologize about my english. It isn't my native language.

 

At the moment, I'm stuck in a form display issue. 

The Datasource of the form: CFC_Brasil_Ferramentas (sharepoint list)

And the Item function is: First(Filter(CFC_Brasil_Ferramentas, SAP = codigo_sap_1.Text)) (yep, i know First isn't delegable. I'm open to alternatives 😄 )

when I enter the codigo_sap.Text with a valid number, the forms works flawlessly. BUT, when I delete all the number at codigo_sap.Text, all the information at the form "disappear". 

I have a label which I would like to be visible, if "Disponivel" appear at the DataCardValue23,

The visible function: If(DataCardValue23.Text = "Disponivel", true, false)

And when an item at form appear with "Disponivel", the visible is true, but when I delete the codigo_sap.Text, it supposed to change to false, but it doesn't happen. The 'true' keep stuck, and messing my layout.

 
When I delete the number at codigo_sap.Text:
IsBlankOrError(DataCardValue23.Text) = true
IsEmpty(DataCardValue23.Text) = false

 

At the previous version of my app, I used a fews 'labels' to works like a Form, It was a bit messy but this routine works like a charm. But when I swaped to a definitive Form to enhance my layout, it happened =(

 

So, any ideas?

Thanks in advance.

5 REPLIES 5
WarrenBelz
Super User
Super User

Hi @Gabe_RookieDev ,

Firstly, this is Delegable

LookUp(
   CFC_Brasil_Ferramentas, 
   IsBlank(codigo_sap_1.Text) || SAP = codigo_sap_1.Text
)

and the Visible property just needs to be

DataCardValue23.Text ="Disponivel"

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

Hi Warren, thanks about your answer.

Thanks for the 'non delegable' function. The function which you post, the same it doesn't works, but I can handle this with LookUp.

 

About the DataCardValue, the problem it isn't the true/false situation at the DataCardValue, but it is at when I change the value of codigo_sap_1.Text to a blank value. It seems the DataCardValue keeps the old value when it supposed to be blank and the label visible doesn't update. 

Hi @Gabe_RookieDev ,

Why use a calculated label? Why not simply test on the value of the Text field becoming blank?

Because I need the value of status. Example: If Status = 'Disponivel', shows label1, if Status = 'Indisponivel', shows label2. 

Both labels have inverse logic at the visible property.

I recorded a video and converted to gif. I think after you watch, you can get the idea what I'm talking about.

 

Hi @Gabe_RookieDev ,

For some reason I cannot open the GIF, but I don't think that will assist. I stopped using calculated labels a long time ago for not only performance reasons (an on-the-fly variable or in-code calculation is always quicker), but also for the reason you are finding - the "order" of calculation of various elements did not always match the desired outcome.

You might have a think on how you can test what you have on the labels in the code to decide what happens.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,355)