cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WarrenBelz Community Champion
Community Champion

Re: Disable A record and Ensure user is not able to use it on the Form

Hi @rmaziwis ,

Sorry for the lateness of this reply.

Firstly, I assume this code is on the OnChange property of the drop-down - also the issue here (now that I have my mind around what you are trying to do) is not the checkbox - it is the field name in the table that the checkbox sets to true. I will call it NotShow in the below - just substitute your field name for this.

I also noticed you have said the field name in the drop-down is Accident Name - I may need a bit more clarification on this, however try this code.

If(
   !isBlank(
      LookUp(
         '[rp].[Accident group]',
         Accidentgroup = DataCardValue46.Selected.'Accident Name' && NotShow.Value = true,
         AccidentGroup
      )
   ),
   Notify("You cannot select this item";
   NotificationType.Error);
   Reset(DataCardValue46)
)

 

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.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (9,152)