Show/hide a button in the ribbon using power Fx

[onyebuchiboss]

Hello All,

What I am trying to do is really basic but for some reason, I have been stuck in this for days now. 

How do I have a button in the ribbon of a model-driven app using Power FX? I have the below code, but it does not seem to work:

If(And(IsBlank(Self.Selected.Item.'Created On'),Or(Text(Self.Selected.Item.'Status Reason') = "100000008", Text(Self.Selected.Item.'Status Reason') = "100000004"),false,true)

I am trying to hide if the created On field is blank and my status is equal to any of the above 2 values, but the button is always present even when the status is equal to any of the above.

Someone, please help. The status is an optionset/choices.

Thanks

[SBax]

You don't need the text() parts, and you should refer to the status fields using the following syntax 

 'Status Reason' (Table).Value

e.g. 'Status Reason' (Account).Active

Give that a try and let me know if you have any issues

[onyebuchiboss]

As you see above, the red error line - "Invalid argument type (OptionSetValue). Expecting a Boolean value instead.". I have removed the integer value in quotes, still same thing

[SBax · Accepted solution]

Here is an example of a similar (albiet simpler approach I have used in the past

If(Self.Selected.Item.'Reservation Status' = 'Reservation Status (Stage Gate Approval Slot Reservations)'.Cancelled,false,true)

This approach will check if the Reservation Status field on a table called Stage Gate Approval Slot Reservations is Cancelled, if it is hide the button, otherwise show it

I would suggest trying to replicate the above with one of your status reasons to see if the rule is working, before adding in the OR condition and the IsBlank later

[onyebuchiboss]

Thanks for responding. I am having a problem where I am not seeing all the options for my status. Look at the image below:

[SBax]

I will attempt to replicate this tomorrow and come back to you

[SBax]

@onyebuchiboss - on occasion the intellisense doesn't show all options. What happens if you type part of the choice name? (e.g. "Not Granted")

[onyebuchiboss]

When I type "Not Granted", I get the error - 'Not Granted not recognised'

[SBax]

Leave it with me, I'll build out the same choice column with the same values and see what I can find out 

[onyebuchiboss]

Thanks. The IntelliSense is showing me old values, the options (text) were recently changed including the values, so I don't know why its showing the older options.