Filtering Issue

(1) Share

Report

Posted on by DeltaMike

Hi All,

I am trying to filter a gallery of questions, by, the category id selected in another gallery to the side(tabs), and also if the callsignID is IN the callsign column of questions.

category filtering works by tabs, but wont filter the callsignIN- the gallery just goes blank !

can you spot a fundamental error ?

Thanks for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SoPatt Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Can you show some sample data like:

What's in the field CallsignID of edEquipmentCheckQuestions?

What's in the CallsignID of EquipmentChecksSelectGallery?

The way you have it appears to indicate (judging by the "in" operator) that edEquipmentCheckQuestions.CallsignID is a single-column table of CallsignIDs and the datasource of EquipmentChecksSelectGallery has a field CallsignID which contains a single value.

Was this reply helpful? Yes No
DeltaMike 12 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi sopatte, I can get it to work now, although my next issue is.

A callsign conflight is PALM 211 being filtered as is also matching PALM 2118 due to having the match within itself.

How Can i filter this and see only the exact term. Thank you

Was this reply helpful? Yes No
Suggested answer

SoPatt Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

It's hard to answer your question because you're not showing me what the data looks like.

The in operator works with strings "in" other strings and rows in a single-column table. I'm not sure which one you are using because I don't know anything about your data. Perhaps don't use the "in" operator but the = operator. It's hard to say without knowing what you're comparing.

What's in the field CallsignID of edEquipmentCheckQuestions?

What's in the CallsignID of EquipmentChecksSelectGallery?

Was this reply helpful? Yes No