Gallery only shows items when there's a specific value

(0) Share

Report

Posted on by JeckGill

242

Hey All,

Feel like I talk here more than I do to my own family lately! But hopefully my last question for at least a week 🙂

I have a collection, as shown below

I want to take only the RatingTitle when RatingScore is equal to "1" or "2" (or 1 or 2 - I am using a global choice if that changes anything"

At the moment I'm using the following, but get an "expected text value" error and don't understand why.

Filter(col_combined, RatingScore = "1" || RatingScore = "2").RatingTitle

I have also tried doing it the followign way, but promptly gave up when ChatGPT bullied me for it

If(
 Or(
 ThisItem.RatingScore = 1,
 ThisItem.RatingScore = 2
 ),
 ThisItem.RatingTitle,
)

Any advice or pointers is greatly appreciated, I feel like I'm being dense and missing something obvious here

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi

You don't need to compare it to text values ("1" or "2"). Instead, you can directly compare it to numeric values.

Filter(col_combined, RatingScore = 1 || RatingScore = 2).RatingTitle

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.

Was this reply helpful? Yes No
JeckGill 242 on at

Like (0)

Report
Copy link

Link copied!

I've tried that already actually, that's why I had the quotes - I should've mentioned that sorry 😅 without the quotes I get a blue underline under the equals signs that says "Incompatible types for comparison. These types can't be compared: Text, Number." as well as a red underline under the .RatingTitle that says "Expected Text value."

I've tried adding .Text and .Value to the end to no avail

Was this reply helpful? Yes No
vaubeee 533 on at

Like (1)

Report
Copy link

Link copied!

Sounds like RatingScore returns Text, so try Value(RatingScore) = 1

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
JeckGill 242 on at

Like (0)

Report
Copy link

Link copied!

is this what you mean? if so, no dice 😕

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you share your Clear collection formula?

Was this reply helpful? Yes No
vaubeee 533 on at

Like (0)

Report
Copy link

Link copied!

.RatingTitle is missing now.

I rebuild it. Both working, so transformation with Value() is not necessary.
Filter(col_combined, Value(RatingScore) = 1 || RatingScore = 2).RatingTitle

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
JeckGill 242 on at

Like (0)

Report
Copy link

Link copied!

I have 4 pages with ClearCollects that are the same as this one. They just create a collection for that page:

Then on the page that comes right before the one I am currently working on for the filter I have the following ClearCollect which combines the previous 4 into one large collection.

The output works, there's an example of it in the initial post - but I did mention that I use a global choice, so the dropboxes you see all use "Choices('Site Inspection Rating')". Could that have something to do with it?

Was this reply helpful? Yes No
JeckGill 242 on at

Like (0)

Report
Copy link

Link copied!

I had tried it both with and without it - blue underline under the equals signs that says "Incompatible types for comparison. These types can't be compared: Text, Number." as well as a red underline under the .RatingTitle that says "Expected Text value."

Was this reply helpful? Yes No
JeckGill 242 on at

Like (0)

Report
Copy link

Link copied!

I just change your version there so that it is
Filter(col_combined, Value(RatingScore) = 1 || Value(RatingScore) = 2).RatingTitle
Now I just have the red underline for the expected text value

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this

Filter(MyCollection,RatingScore = "1" || RatingScore = "2")

Was this reply helpful? Yes No