Unanswered

Show selected data after logging in

(0) Share

Report

Posted on by audrey_e_t

Hi! In need of help with this problem,

User logs in by typing idB to TextInputB and gets access uses idB and emailB. After that, it shows a gallery where I only want to show data from tableA that contains idB. After that, they will input grades to tableC using patch.

I tried LookUp(tableA, Value(TextInputB.text) = idA) and Filter(tableA, Value(TextInputB.text) = idA) on Gallery's Items but both wont show the selected data. Also tried Set(thisIDB, ThisItem) on the Button to submit TextInputB but it wont work too.

Here's some info about the data :

tableA : idA, nameA, universityA, idB

tableB : idB, nameB, emailB

tableC : idA, grades

& all id is in Number format.

Please let me know if you need more information.

Hope someone can help, thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

BideyYusuf 387 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @audrey_e_t
You can just use Filter(TableA,IdA=Value(TextInputB.Text))

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @audrey_e_t ,
Try using below formula in Items property of your galley control-
Filter(tableA, idB = Value(TextInputB.text))

Was this reply helpful? Yes No
audrey_e_t 17 on at

Like
a
(0)

Report
Copy link

Link copied!

i have also tried that and it also won't work 😞

Was this reply helpful? Yes No
BideyYusuf 387 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @audrey_e_t .. I did a scenario of what you planned to do, it worked okay. unless we havent gotten the information right.
anyway, do you have IdA as a value in the TableA?

what i believe you want to do, is used the credentials or ID to filter the record in the gallery when you Navigate there. if this is so, you must have IdA as a value inside the table, in order to use the textInput to filter using the value. @audrey_e_t

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @audrey_e_t ,

Maybe you can try below first, :

On the Button which submits TextInputB

Set(thisIDB, Value(TextInputB.Text))

On Gallery Items:

Filter(tableA, idB = thisIDB)

Or you'd better share more info of your data sources, are they Excel tables or any else?

Best regards,

Was this reply helpful? Yes No