IF-Conditions with multiple statements

(0) Share

Report

Posted on by Usr21

Hello everyone,

I set multiple variables for the IF-Conditions but it doesn't work.

# ### VAR
SET TageZweiAcht TO FormattedDateMonth = 'Februar'
SET TageDreiNull TO FormattedDateMonth = 'April' OR FormattedDateMonth = 'Juni' OR FormattedDateMonth = 'September' OR FormattedDateMonth = 'Oktober'
SET TageDreiEins TO FormattedDateMonth = 'Januar' OR FormattedDateMonth = 'März' OR FormattedDateMonth = 'Mai' OR FormattedDateMonth = 'Juli' OR FormattedDateMonth = 'August' OR FormattedDateMonth = 'Oktober' OR FormattedDateMonth = 'Dezember'


# ### DATE
DateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime
Text.FromCustomDateTime DateTime: ResultedDate CustomFormat: $'''MMMM''' Result=> FormattedDateMonth

# ### IF-COONDITIONS
IF FormattedDateMonth = TageZweiAcht THEN
 Display.ShowMessage Message: FormattedDateMonth Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False
END

IF FormattedDateMonth = TageDreiNull THEN
 Display.ShowMessage Message: FormattedDateMonth Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False
END

IF FormattedDateMonth = TageDreiEins THEN
 Display.ShowMessage Message: FormattedDateMonth Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False
END

Do I make a mistake at the variables?

How can I set multiple variables for IF 🤔

Categories:

Process mining

I have the same question (0)

All responses (4)

Answers (1)

fraenK 2,125 on at

Like (1)

Report

You set conditions in the if statement, not the variable statement
https://docs.microsoft.com/en-us/power-automate/desktop-flows/use-conditionals
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation#logical-operators

Was this reply helpful? Yes No
Usr21 22 on at

Like (0)

Report
@fraenKthank you for your support! 👍

It doesn't also work

IF FormattedDateMonth = (TageDreiEins = 'Januar' OR TageDreiEins = 'März' OR TageDreiEins = 'Mai' OR TageDreiEins = 'Juli' OR TageDreiEins = 'August' OR TageDreiEins = 'Oktober' OR TageDreiEins = 'Dezember') THEN Display.ShowMessage Message: $'''%FormattedDateMonth% %TageDreiEins%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False END

The variable "TageDreiEins" is false 🤔

Was this reply helpful? Yes No
Verified answer

fraenK 2,125 on at

Like (1)

Report
The correct syntax is
IF (FormattedDateMonth = 'Januar' OR FormattedDateMonth = 'März') = True THEN
But it would be easier to create a list with all the months and then use "contains" like
IF %ListVariable% contains %FormattedDateMonth%

Was this reply helpful? Yes No
Usr21 22 on at

Like (0)

Report
@fraenK best man! 😃

Here's my solution with a list contained all the month.
Maybe helps someone else

SET MonatDreiEins TO $'''Januar, März, Mai, Juli, August, Oktober, Dezember''' SET MonatDreiNull TO $'''April, Juni, September, November''' SET MonatZweiAcht TO $'''Februar''' DateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime DateTime.Add DateTime: CurrentDateTime TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> ResultedDate Text.FromCustomDateTime DateTime: ResultedDate CustomFormat: $'''yyyy.MM''' Result=> FormattedDateTime Text.FromCustomDateTime DateTime: ResultedDate CustomFormat: $'''MMMM''' Result=> FormattedDateMonth IF Contains(MonatDreiEins, FormattedDateMonth, False) THEN Display.ShowMessage Title: $'''!!!''' Message: 31 Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ELSE IF MonatDreiNull = FormattedDateMonth THEN Display.ShowMessage Title: $'''!!!''' Message: 30 Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ELSE Display.ShowMessage Title: $'''!!!''' Message: 28 Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False END

Was this reply helpful? Yes No