web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery not showing data

Power Apps

Answered

Gallery not showing data

(0) Share

Report

Report

Posted on by audrey_e_t

17

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 Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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

Join the conversation