Power Platform Community Forum Thread Details

If(

!IsBlank(DRP_StaffType.Selected.Value) && !IsBlank(Txtin_FullName.Text) && !IsBlank(Drp_EmailContainsIcrisat.Selected.Value) && !IsBlank(DRP_Device.Selected.Value),If(Drp_EmailContainsIcrisat.Selected.Value ="Yes" && DRP_Device.Selected.Value ="Laptop official" && !IsBlank(DRP_Email.Selected.Mail) && !IsBlank(Txtin_LAN.Text) && !IsBlank(Txtin_Tenure.Text) && Value(Txtin_Tenure.Text)<=12,DisplayMode.Edit,If(Drp_EmailContainsIcrisat.Selected.Value ="Yes" && (DRP_Device.Selected.Value = "Laptop personal"||DRP_Device.Selected.Value = "Only for mobile") && !IsBlank(DRP_Email.Selected.Mail),DisplayMode.Edit,If(Drp_EmailContainsIcrisat.Selected.Value ="Yes" && DRP_Device.Selected.Value ="Not applicable" &&

!IsBlank(DRP_Email.Selected.Mail),DisplayMode.Edit,DisplayMode.Disabled)),If(Drp_EmailContainsIcrisat.Selected.Value = "No" && DRP_Device.Selected.Value = "Laptop official" && !IsBlank(Txtin_LAN.Text) && !IsBlank(Txtin_Tenure.Text) && Value(Txtin_Tenure.Text)<=12,DisplayMode.Edit,If(Drp_EmailContainsIcrisat.Selected.Value = "No" && (DRP_Device.Selected.Value ="Laptop personal"||DRP_Device.Selected.Value = "Only for mobile") && !IsBlank(Txtin_LAN.Text) && !IsBlank(Txtin_Tenure.Text) && Value(Txtin_Tenure.Text)<=12,DisplayMode.Edit,If(Drp_EmailContainsIcrisat.Selected.Value = "No" && DRP_Device.Selected.Value ="Not applicable",DisplayMode.Edit,DisplayMode.Disabled)),DisplayMode.Disabled

)

This is my formulae.....

Half of it is working till

If(

For NO condition I have written like above but it is not working and a ) expected and I am bit confused where sholud I place?

Please help

Categories:

Building Power Apps

Hi @UshaJyothi20 ,

By applying some formatting I found there are two closing parenthesis missing at the end. Please try:

If(
 !IsBlank(DRP_StaffType.Selected.Value) && 
	!IsBlank(Txtin_FullName.Text) && 
	!IsBlank(Drp_EmailContainsIcrisat.Selected.Value) && 
	!IsBlank(DRP_Device.Selected.Value),
	If(
		Drp_EmailContainsIcrisat.Selected.Value ="Yes" && 
		DRP_Device.Selected.Value ="Laptop official" && 
		!IsBlank(DRP_Email.Selected.Mail) && 
		!IsBlank(Txtin_LAN.Text) && 
		!IsBlank(Txtin_Tenure.Text) && 
		Value(Txtin_Tenure.Text)<=12,
		DisplayMode.Edit,
		If(
			Drp_EmailContainsIcrisat.Selected.Value ="Yes" && 
			(DRP_Device.Selected.Value = "Laptop personal" || DRP_Device.Selected.Value = "Only for mobile") && 
			!IsBlank(DRP_Email.Selected.Mail),
			DisplayMode.Edit,
			If(
				Drp_EmailContainsIcrisat.Selected.Value = "Yes" &&
				DRP_Device.Selected.Value ="Not applicable" &&
				!IsBlank(DRP_Email.Selected.Mail),
				DisplayMode.Edit,
				DisplayMode.Disabled
			)
		),
		If(
			Drp_EmailContainsIcrisat.Selected.Value = "No" && 
			DRP_Device.Selected.Value = "Laptop official" && 
			!IsBlank(Txtin_LAN.Text) && 
			!IsBlank(Txtin_Tenure.Text) && 
			Value(Txtin_Tenure.Text)<=12,
			DisplayMode.Edit,
			If(
				Drp_EmailContainsIcrisat.Selected.Value = "No" && 
				(DRP_Device.Selected.Value ="Laptop personal" || DRP_Device.Selected.Value = "Only for mobile") && 
				!IsBlank(Txtin_LAN.Text) && 
				!IsBlank(Txtin_Tenure.Text) && 
				Value(Txtin_Tenure.Text)<=12,
				DisplayMode.Edit,
				If(
					Drp_EmailContainsIcrisat.Selected.Value = "No" && 
					DRP_Device.Selected.Value ="Not applicable",
					DisplayMode.Edit,
					DisplayMode.Disabled
				)
			),
			DisplayMode.Disabled
		)
	)
)

Ps. By making use of && and || operators more, you can get rid of the nested If functions and duplicated conditions.