Answered

Multiple Field Validation to Show Save Edit Button

(0) Share

Report

Posted on by ChrisL58

Multi Condition Validation.
Hello,
I posted about this but wasnt able to get a resolution.
Solved: Re: Validation Before Submission - Power Platform Community (microsoft.com)

I have a person group field and other required fields that need to be populated with a value.
Here is a form that is challenging. Below is the form before a Yes/No toggle is set to Yes.
There is one required field called cboFundingTeamColleague when the toggle is set to "No".

If the Yes/No toggle is set to "Yes" the form has more required fields that must be set to yes before the "Save Edit" button is enabled.

Notice that one of the controls is set to "No" but yet the Save Edit button is still enabled.

If(DataCardValue36.Value=true && IsBlank(cboFundingTeamColleague.Selected.DisplayName),DisplayMode.Edit,DisplayMode.Disabled || If(DataCardValue36.Value=true && !(Len(RichTextEditor1.HtmlText) = 0),DisplayMode.Edit,DisplayMode.Disabled || If(DataCardValue25.Selected.Value = "Yes" && DataCardValue28.Selected.Value = "Yes" && DataCardValue23.Selected.Value = "Yes" && DataCardValue24.Selected.Value = "Yes",DisplayMode.Edit, DisplayMode.Disabled)))

Can anyone help me determine what I am missing?
Thank you

Categories:

General Questions

All responses (4)

Answers (1)

ChrisL58 on at

Like (0)

Report

Re: Multiple Field Validation to Show Save Edit Button

Well, I thought it was working.
I found out where the formula is failing but the editor for the control doesn't complain.
The Save Edit button should be disabled but it persists.
If(!Len(RichTextEditor1.HtmlText) = 0,DisplayMode.Disabled)
However, if I use
If(IsBlank(RichTextEditor1.HtmlText) = true,DisplayMode.Disabled) the button is disabled.
ChrisL58 on at

Like (0)

Report

Re: Multiple Field Validation to Show Save Edit Button

Hi Jeff,
If(
!DataCardValue36.Value && IsBlank(cboFundingTeamColleague.Selected.DisplayName) || IsBlank(RichTextEditor1.HtmlText) = true,
DisplayMode.Disabled,
If(
DataCardValue25.Selected.Value = "Yes" && DataCardValue28.Selected.Value = "Yes" && DataCardValue23.Selected.Value = "Yes" && DataCardValue24.Selected.Value = "Yes",
DisplayMode.Edit,
DisplayMode.Disabled
)
)
ChrisL58 on at

Like (0)

Report

Re: Multiple Field Validation to Show Save Edit Button

Hi Jeff,
Thanks for responding
Yes, datacardvalue36 is the toggle.
I will try what you suggested.

Thanks.
Verified answer

v-jefferni on at

Like (1)

Report
Re: Multiple Field Validation to Show Save Edit Button

Hi @ChrisL58 ,

Where is the toggle control, is it DataCardValue36? Which control is it within the two screenshots?

I try to understand the logic and sort the formula based on my understanding:

If( !DataCardValue36.Value, DisplayMode.Disabled, If( IsBlank(cboFundingTeamColleague.Selected.DisplayName) || Len(RichTextEditor1.HtmlText) = 0, DisplayMode.Disabled, If( DataCardValue25.Selected.Value = "Yes" && DataCardValue28.Selected.Value = "Yes" && DataCardValue23.Selected.Value = "Yes" && DataCardValue24.Selected.Value = "Yes", DisplayMode.Edit, DisplayMode.Disabled ) ) )

Best regards,