Unanswered

Warning message on If function

(0) Share

Report

Posted on by Cathleen307

I have the following function that is giving me a warning message that I cannot figure out

If(NewDiaryIssueDD.Selected.Value=!"Machine Fault (Controls)", Patch(ProcessDiary, Defaults(ProcessDiary), {Title: User().FullName, Date: Now(), AreaCell: NewDiaryItemAreaLbl.Text, Issue: NewDiaryIssueDD.Selected, SafetyRisk: NewDiaryItemSafetyDD.Selected, JITNonJIT: NewDiaryItemJITDD.Selected}); Navigate(StartingOptions), Patch(ControlsDiary, Defaults(ControlsDiary), {Priority: NewDiaryPriorityInput.Selected, ProcessDiaryID: VarX, RequestedBy: CurrentUser}))

I'm used to Excel functions, which is why my statement is a single line, but having said that, the warning message is as follows:

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

dgatewood 34 on at

Like
a
(1)

Report
Copy link

Link copied!

Try <> instead of =!
dgatewood 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Also noticed the CurrentUser, I would ultimately replace that as User().DisplayName or User().Email. I'm guessing that's already being done by a variable but for performance eliminating repititive set functions that are Delcarative
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Cathleen307
1. Syntax to check not equal to condition within IF statement is "If( a<>b,true,false)".
2. From the above If condition in the screenshot, you are comparing two different datatypes, Text and Boolean. Please check your comparison once.
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Cathleen307

I agree with @dgatewood

The inequality operator is <>, rather than =!. So if the target predicate of your If statement is test that NewDiaryIssueDD.Selected.Value isn't equal to "Machine Fault (Controls)", the correct syntax would be:

If(NewDiaryIssueDD.Selected.Value <> "Machine Fault (Controls)", Patch(ProcessDiary,.....