Unanswered

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report
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,

Was this reply helpful? Yes No
ChrisL58 on at

Like (0)

Report

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

Thanks.

Was this reply helpful? Yes No
ChrisL58 on at

Like (0)

Report

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
)
)

Was this reply helpful? Yes No
ChrisL58 on at

Like (0)

Report

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.

Was this reply helpful? Yes No