I have formulas like this one
If(
If(
Value(label_year.Text) < Value(CurrentYear.Text),
false,
Value(CurrentMonth.Text) <= ThisItem.Month Or Value(label_year.Text) > Value(CurrentYear.Text)
),
DisplayMode.Disabled,
DisplayMode.Edit
)
Basically if the current year and current month are in the past they should be set to Disabled, otherwise they should be set to Edit. As you can see 2019 and 2020 in blue both are editable.
The other issue with this is now in 2022 or any later year that fields that should be open to enter information is greyed out and the open ones in blue when you type anything immediately grey out even if you are not finished. This is what is in that Original field If(IsBlank(TextInput2_6), DisplayMode.Edit, DisplayMode.Disabled)
I am stumped why this is not working
Any help would be appreciated.
Solved! Go to Solution.
The formula that seemed to do the trick was:
If((IsBlank(ThisItem.RevForeCast) && (Date(ThisItem.Year, ThisItem.Month, 1) > Date(Year(Now()), Month(Now()), 1))) ||
(Date(ThisItem.Year, ThisItem.Month, 1) = Date(Year(Now()), Month(Now()), 1)), Edit, Disabled)
Hi @Dorinda ,
Try a different approach to avoid the "complicated condition". 😊. What about ...
If(
Value(label_year.Text)*12+ThisItem.Month < Value(CurrentYear.Text)*12+Value(CurrentMonth.Text),
DisplayMode.Disabled,
DisplayMode.Edit
)
Hope it helps !
H @Dorinda ,
This should work
If(
Value(label_year.Text) > Value(CurrentYear.Text) ||
(
Value(CurrentMonth.Text)>= ThisItem.Month &&
Value(label_year.Text) = Value(CurrentYear.Text)
),
DisplayMode.Edit,
DisplayMode.Disabled
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
The formula that seemed to do the trick was:
If((IsBlank(ThisItem.RevForeCast) && (Date(ThisItem.Year, ThisItem.Month, 1) > Date(Year(Now()), Month(Now()), 1))) ||
(Date(ThisItem.Year, ThisItem.Month, 1) = Date(Year(Now()), Month(Now()), 1)), Edit, Disabled)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
206 | |
98 | |
58 | |
51 | |
42 |
User | Count |
---|---|
262 | |
158 | |
85 | |
79 | |
57 |