Gallery not showing data

[audrey_e_t]

Hi! Fairly new and still learning about PowerApps and I need some help 🙂

I have a gallery where it shows student's data after the teacher typed their ID. But the problem is, the teachers can have only one student OR the have two and more students.

Case 1 : Used LookUp but they only show the first data with the ID. (Other students with the same ID won't show up because.. it's a LookUp)

Case 2 : Changed it to Filter but the data for teachers with only ONE student won't show up.  (Only shows students who have the same ID)

My codes :

Case 1 : LookUp(StudentData, IDMentor = TextInput1.Text)

Case 2 : Filter(StudentData, IDMentor = TextInput1.Text)

Can I join both LookUp and Filter using an IF statement ?? Tried using the IF and ISBLANK but I suck so it didn't work 😞

Need your help please! lmk if you need more info

Thank you!

[v-jefferni · Accepted solution]

Hi @audrey_e_t ,

Could you please share more details about your scenario? Generally speaking, the case 2 with Filter formula should work exactly. So, what is your data source? What's the data type for the IDMentor column? If it is a Number column, maybe you can try and convert the input text to number then filter:

Filter(StudentData, IDMentor = Value(TextInput1.Text))

Best regards,

[audrey_e_t]

Hi @v-jefferni,

Adding the 'value' really did the job! IDMentor is a Number Column and just fyi the data is Excel Online.

Thank you so much!