cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
audrey_e_t
Regular Visitor

Gallery not showing data

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

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,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
v-jefferni
Community Support
Community Support

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,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

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!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,874)