Gallery filtered using two combo boxes quits working when adding a third

(0) Share

Report

Posted on by mkusler

237

I have the following code in the "Items" property of a gallery and everything works as expected.

Filter(
Intake_Repository,
Status.Value <> "Submittal" &&
WorkingTeam.Value = "Continuous Improvement" &&
(Status.Value <> "Acknowledge") &&
(Status.Value <> "Closed"),

IsBlank(RequestTypeCB.Selected.Result) ||
IsEmpty(RequestTypeCB.SelectedItems) ||
RequestType = RequestTypeCB.Selected.Result,

IsBlank(PrimaryAssignedCB.Selected.Result) ||
IsEmpty(PrimaryAssignedCB.SelectedItems) ||
AssignedPrimary.DisplayName = PrimaryAssignedCB.Selected.Result
)

However, when I tried to add a third filter condition using another Combo Box using the following code, the code is accpeted but the gallery doesn't return any results.

Filter(
Intake_Repository,
Status.Value <> "Submittal" &&
WorkingTeam.Value = "Continuous Improvement" &&
(Status.Value <> "Acknowledge") &&
(Status.Value <> "Closed"),

IsBlank(RequestTypeCB.Selected.Result) ||
IsEmpty(RequestTypeCB.SelectedItems) ||
RequestType = RequestTypeCB.Selected.Result,

IsBlank(StatusCB.Selected.Result) ||
IsEmpty(StatusCB.SelectedItems) ||
Status.Value = StatusCB.Selected.Result,

IsBlank(PrimaryAssignedCB.Selected.Result) ||
IsEmpty(PrimaryAssignedCB.SelectedItems) ||
AssignedPrimary.DisplayName = PrimaryAssignedCB.Selected.Result
)

Does anyone have any idea as to what I am doing wrong?

The "=" sign after "Status.Value" is underlined with the following error. "Incompatible Types For Comparison. These Types Can't be Compared. Text, Record"

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

This means that StatusCB.Selected.Result is returning a record value, and Status.Value is a text value, and these can't be compared. What type of data are the choices for StatusCB?

You may have to either replace the .Result or add something else on after it, specifying what part of the choice you're comparing(i.e StatusCB.Selected.Status, if "Status" was a field of the records stored in StatusCB's choices)
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

The error message suggests that you're trying to compare incompatible types: Text and Record. It seems that the Status.Value property is of type Text, while StatusCB.Selected.Result is of type Record.

Status.Value = (StatusCB.Selected.Result).Value

Or

Status.Value = (StatusCB.Selected.Result.Value)

Reference Link : Power Apps Choices Function with Examples - SPGuides

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.