Unanswered

Display Person Name on Combo box by using of ID

(0) Share

Report

Posted on by spiderkzn

141

Hi,

I'm struggle to display Person Name on Combobox in gallery.

On combobox it link to table [Person] from SQL which it list all of person detail include PersonID.

When I extract the information from [Owner] table which it have PersonID in Stored Procedure.

So I need to display Person Name on Combobox with match of Person ID.

How do I achieve it?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ashwin7104 671 on at

Like (0)

Report

Hey @spiderkzn ,

See if the below method works for you,

1) Store the [Person] table to a variable using Set function

2) Then use LookUp(Personvariable, PersonID = ThisItem.PersonID).PersonName. Assuming [Owner] table is given in Items property of the gallery.

Thanks.

Was this reply helpful? Yes No
spiderkzn 141 on at

Like (0)

Report

Hi Ashwin,

Your answer is right but almost. As I've figure out. It working. thank you.

What I use in DefaultSelectedItems in Combobox and the function is:

Table({Value:LookUp(Person, PersonID = ThisItem.PersonID).Person_Name})

Was this reply helpful? Yes No
spiderkzn 141 on at

Like (0)

Report

there is other problem.

The person name does display on combobox. But the problem is the combobox does not provide the PersonID. how do I ensure Combobox include PersonID?

Was this reply helpful? Yes No
Verified answer

spiderkzn 141 on at

Like (0)

Report

Just let you know I've solved the problem 🙂 here the solution that it will help other.

DefaultSelectedItems = Filter(Person,PersonID=ThisItem.PersonID)

Was this reply helpful? Yes No