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.
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.
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
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.
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.
Check out the News & Announcements to learn more.
Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.