Custom command visibility condition on LookUp column

[TarikBenSallam]

Hello,
I have a subgrid that shows a list of articles associated to a record Contract .

An article has a LookUp Column "Formule" , which associates my article to a record in a table "Formule"

I've created a custom command on the "Article" Table and i'm trying to make it visible when the "Formule" column is empty ( like in Article66 in the image above ) .
But I can't seem to find the right way to add a condition on the Lookup Column ( Formule ) .

I've tried  : (CountRows(Self.Selected.AllItems) = 1 && IsBlank(Self.Selected.Item.Formule)) and other formulas but it doesn't work properly . 

So i'm looking for the condition that will make my custom command visible when the "Formule" column of an article doesn't Exist .

Thank you in advance .

[WarrenBelz]

Hi @TarikBenSallam ,

If that is all in the same gallery, all you need is

IsBlank(ThisItem.Formule)

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.

Visit my blog Practical Power Apps

[TarikBenSallam]

Hello @WarrenBelz , no it's not a gallery , that's a subgrid in Model Driven App . And i'm trying to add a Custom Command .

"ThisItem" doesn't exist in this context .
However , to my understanding, its equivalent should be Self.Selected.Item in this context . But IsBlank(Self.Selected.Item.Formule) is not working for me .

Thank you for taking the time to help .

Edit : 
In fact, after some tests, IsBlank(Self.Selected.Item.Formule) is always true . Even if my article has a Formule .. 
And when i Use the IsBlank(Self.Selected.Item."other columns") with "other colums" being the other normal fields , it works as expected . So the problem is with the LookUp Column ! 

[WarrenBelz]

Hi @TarikBenSallam ,

It would have been be very useful to mention that you have a model-driven app - most posts on this forum are for Canvas or Integrated Apps. I am sorry, but I do not use them - someone else should be able to pick this up.

[EricRegnier]

Hi @TarikBenSallam,

You can do this with the Self.Selected.Item.<field name> expression. Here's an example:

IsBlank(Self.Selected.Item.Make)

The button will show if the Make field is blank

Hope this helps!

[TarikBenSallam]

Hi @EricRegnier ,
Is the "Make" field in your case a LookUp Column? 
The solution you've indicated is what i've been trying from the start and it works with all the other fields except the field i'm trying to use (Formule) , which is a LookUp column .
So can you please try the same thing with a LookUp column and tell me if it works for you . 
Thank you !

[EricRegnier]

I get the same thing with lookups, there are not showing in the intellissense. I have contacted the product team to see if it is supported yet. Will keep you posted!

[Anonymous]

Hi @EricRegnier Any updates from MS on this? I ran into the same issue (cannot get details about LookUp fields for custom commands) and I need it to make my functionality work.

Thanks for any info

[EricRegnier · Accepted solution]

Hi @Anonymous, @TarikBenSallam, apologies for late reply. Microsoft has acknowledged these bugs and will be resolving it, unfortunately no ETA yet. Cheers

[melamri]

Hi,

I think this is not an issue anymore. Could you please check in your environments?