Answered

Gallery not showing data

(0) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
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,

Was this reply helpful? Yes No
audrey_e_t 17 on at

Like (0)

Report

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!

Was this reply helpful? Yes No