Unanswered

Grab Information from another Table based on ComboBox Selection

(0) Share

Report

Posted on by ajmastr

In the app that I am creating, I need certain text labels to auto populate with data based on the selection of a ComboBox.

In this instance, the ComboBox is locked to only accepted one selection. This is so that the user can only select one Case title from a specific Object item view. Once that Case is selected, I need the PowerApp to go and pull the information from the actual Case Table, so that I can then grab the Customer name and Site address to be applied to text labels in the PowerApp. How would I go about doing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!
A safe bet to find a record from a datasource is to use the lookup function.
As an example, to find the customer name, you might try something like:
LookUp(*YourDataSource*, Title = *YourCombobo*.Selected.*Title*).*Customer Name*
Then you just put that in the label's text field.
Of course, you have to input your appropriate fields in that formula, but it will accomplish what you want.

Hope this helps!

Was this reply helpful? Yes No
ajmastr 45 on at

Like (0)

Report
Copy link

Link copied!
I see, I formatted the LookUp function correctly for my instance and it looks something like this:

LookUp(Cases, 'Case Title' = techopsview_cases.Selected, Client)

However, the Client field on the Dataverse table that I am referencing is a Look Up field, and the PowerApps expression says that it expects a Text value, how should I get around this?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
I think you should be able to select another field from the looked up value. Perhaps something like:
LookUp(Cases, 'Case Title' = techopsview_cases.Selected, Client.Title)

Was this reply helpful? Yes No