Answered

If statement Not equal to

(0) Share

Report

Posted on by PowerAid

I am trying to write an If statement like "If(IsBlank(field)" but I need it to be "If not = to "Select...""(field)" How can you write something like that? I want the action to run as long as the field value is not "Select..."

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

seadude 1,855 on at

Like (0)

Report
Copy link

Link copied!
Hm.

Its tough for me to understand exactly what you are looking for here. But I'll try:
It sounds like you have a Textbox with "Select x" in it and you want to say,
If textbox.text has the string "Select x" in it, do something.
If thats the case try:
If( IsMatch(textBox.Text, "Select x"), doSomethingCool, beLame )
I tested this. It works. Here are the docs. When in doubt, consult Mr. Dang (a true treasure to the PowerApps community)!

Was this reply helpful? Yes No
PowerAid on at

Like (2)

Report
Copy link

Link copied!
IsMatch(textBox.Text, "Select x"), doSomethingCool, beLame )
I tested this. It works. Here are the docs. When in doubt, consult Mr. Dang (a true treasure to the PowerApps community)!
Ok. I am actually wanting a Patch to NOT run if the value of the dropdown = "Select..." . Is there an opposite of IsMatch?

This is part of a repeating table that I have designed. The Patch will write values to my SharePoint list ('Revenue Pre-Defined Categories'). One of the fields in my repeating table is a dropdown and I dont want it to write to SharePoint if that dropbown has not been set to something other than Select.

ForAll(RevenuePreDefinedCollection, Patch('Revenue Pre-Defined Categories', Defaults('Revenue Pre-Defined Categories'), {Title: CategoryCC, AmountEach: AmountEachCC, Quantity: QuantityCC, Subtotal: SubtotalCC, MasterID: Form1.LastSubmit.ID}))

@seadude wrote:
Hm.

Its tough for me to understand exactly what you are looking for here. But I'll try:
It sounds like you have a Textbox with "Select x" in it and you want to say,
If textbox.text has the string "Select x" in it, do something.
If thats the case try:
If(

Was this reply helpful? Yes No
Verified answer

seadude 1,855 on at

Like (0)

Report
Copy link

Link copied!

Aha. You can usually put a “!” in front of your statement to make it a “NOT”.

Another option may be:
- Set the Submit Button DisplayMode Property to:

If(
Dropdown.Selected.Value = “Select”,
DisplayMode.Disabled,
DisplayMode.Edit
)

This is a type of manual error handling you can use for different things.
Coupled with some And() / Or() functions make it quite powerful.

Was this reply helpful? Yes No
NickSoan 16 on at

Like (6)

Report
Copy link

Link copied!

The Microsoft DAX language for the PowerPlatform tools doen't have the operator !=, but it does have <>

If( DropDown.Selected.Value <> "View", DisplayMode.Disabled, DisplayMode.Edit )

Was this reply helpful? Yes No