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
Copy link

Link copied!

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
Copy link

Link copied!
@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
Copy link

Link copied!
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
Copy link

Link copied!
@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