Formula problem (Incompatible Type. We can't evaluate your formula because the values being compared in the formula aren't the same type.

(0) Share

Report

Posted on by Elitezone

909

Hello,

I have a problem with this formula:

If(DataCardValue18.Selected.Value =! "Legal Law";true;false) && !IsBlank(DataCardValue22.Text); Notify("To write a text you need a Legal Law category.";

It prints error : (Incompatible Type. We can't evaluate your formula because the values being compared in the formula aren't the same type.

And does not work.

I DataCardValue18 is a combo box multi choice - DataCardValue22 is a text field that is active only if Legal Law is provided in DataCardValue18.

Right now in my app you can set legal law category for a second and provide a datacardvalue22 value - then you can uncheck this category and the text will remain.

I want to avoid it with this validation.

I also tried to:

If("Legal Law" not in DataCardValue18.SelectedItems.Value && !IsBlank(DataCardValue22.Text);
Notify("Description.";
NotificationType.Error);

Not to seems not to work.

There might be not enough )))) at the end but it is because this is a part of a bigger formula.

Everything seems to work bot not this...

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Try this:

If("Legal Law" not in DataCardValue18.SelectedItems.Value && !IsBlank(DataCardValue22.Text); Notify("Description";NotificationType.Error))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Elitezone 909 on at

Like
a
(0)

Report
Copy link

Link copied!
Invalid amount of argument. Received 1, expected 2
Expected operator. In this place of formula operator like + * & is expected.
Invalid usage of .

This is my whole formula, and I want this validation to be added to it:

If(IsBlank(DataCardValue11.Text);Notify("Add name.";NotificationType.Error); If(IsBlank(DataCardValue18.Selected.Value);Notify("Add category.";NotificationType.Error); If("Legal Law" in DataCardValue18.SelectedItems.Value && IsBlank(DataCardValue22.Text); Notify("If you chose Legal Law you need to provide a description."; NotificationType.Error); If(Len(DataCardValue19.Text) < 79;Notify("In descrption field you need at least 80 characters.";NotificationType.Error); If(IsBlank(DataCardValue9.Selected.Value);Notify("You need to provide a range of modification.";NotificationType.Error); UpdateContext({variableDefault:" "});UpdateContext({showDialog:true;variableDefault:""}))))))
This formula works well, but I need this one validation in it.

Was this reply helpful? Yes No
Elitezone 909 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone?

Was this reply helpful? Yes No
Elitezone 909 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone?
Bump.

Was this reply helpful? Yes No