You’re offline. This is a read only version of the page.
22
Hello everyone,
I set multiple variables for the IF-Conditions but it doesn't work.
Share
Report# ### 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 🤔
@fraenK best man! 😃
Here's my solution with a list contained all the month.
Maybe helps someone else
All responses (
Answers (
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
The correct syntax is
IF (FormattedDateMonth = 'Januar' OR FormattedDateMonth = 'März') = True THENBut it would be easier to create a list with all the months and then use "contains" like
IF %ListVariable% contains %FormattedDateMonth%
@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 🤔
You set conditions in the if statement, not the variable statement
https://docs.microsoft.com/en-us/power-automate/desktop-flows/use-conditionals
