LookUp() from Dropdown and display value from List

(1) Share

Report

Posted on by ZachFlem

Hi Folks,

I have a dropdown in my app that is populated based on a column from List1.

I want to then use that dropdown to display a value from another column in the same list.

The dropdown has been named 'dropdownIMEI' and in the TextInput field that I want the device type displayed, i have the followingin the Data/Default field on the Advanced tab of the field settings.

This results in the error:

"Incompatible Types for Comparison. These types can't be compared: Table, Text"

I have tried numerous combinations of 'selected.text' etc to get it to work, but either run into full blown errors or warnings that don't display anything in the text field.

I suspect that I am either not far from this working, or miles from the mark!

Appreciate your assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ZachFlem ,

What is type of "IMEI" column and what is Items of DropDown?
If "IMEI" is multiple selection column in your list, please try this:
LookUp(ListName,DropdownName.Selected.Value in IMEI.Value,DeviceTypeColumnName)

Best regards,
Rimmon

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @ZachFlem

Given your scenario, you want to display a value from another column in List1 based on the selection in the dropdown ‘dropdownIMEI’. Here’s a general approach to fix this issue:

Use Proper Property for Display: In the text input control where you want to display the device type, you should reference the selected item of the dropdown. However, you need to ensure you are referencing the correct property of the selected item.
Assuming dropdownIMEI is populated with items from List1 and you want to display a column (say ‘DeviceType’) from the same list, the formula in the Default property of the TextInput should be something like:

LookUp(List1, YourIdentifierColumn = dropdownIMEI.Selected.YourIdentifierColumn, DeviceType)

Here, YourIdentifierColumn is the column used to identify records in List1.
The LookUp function searches List1 for a record where ‘YourIdentifierColumn’ matches the selected item in dropdownIMEI, and then it retrieves the ‘DeviceType’ from that record.

If you continue to face issues, could you provide the specific formula you’re using? That would help in giving a more precise solution.

Was this reply helpful? Yes No
ZachFlem 17 on at

Like (0)

Report
Copy link

Link copied!

The IMEI column contains text, a 15 char number per row.

The Model column contains a multi selection

I updated my formula as per your suggestion, and while I no longer get an ERROR, i am getting a delegation warning

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

Like (0)

Report
Copy link

Link copied!
Hi @ZachFlem ,

Please modify the formula:

LookUp(Inventory,IMEI=dropdownIMEI.Selected.Value,Concat(Model,Value,","))

Was this reply helpful? Yes No
ZachFlem 17 on at

Like (0)

Report
Copy link

Link copied!

Using your provided suggestions, I have updated the formula to the following:
LookUp(Inventory, IMEI = dropdownIMEI.Selected.IMEI, Model)

The error now is: "Expected Text value"

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

Like (0)

Report
Copy link

Link copied!
Hi @ZachFlem ,

Since your model is a multiple selection column, it's a table rather than text (text input expects text), so I recommend using the Concat function to display value of Model column in text input.
LookUp(Inventory,IMEI=dropdownIMEI.Selected.Value,Concat(Model,Value,","))

Best regards,
Rimmon

Was this reply helpful? Yes No
Verified answer

ZachFlem 17 on at

Like (1)

Report
Copy link

Link copied!
Thanks everyone for your suggestions, I now have this working.

Despite all the great suggestions, the solution in the end was as follows:

LookUp(Inventory, IMEI = dropdownIMEI.Selected.IMEI, Model.Value)

I just added the '.Value' after the final selector and I now have the text fields populating with the desired info from the list.

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

Like (0)

Report
Copy link

Link copied!

Hi @ZachFlem ,

It looks like Model column is a single-choice column and you don't have the multi-select setting turned on. In summary, the value of the choice column is stored in a column named Value.
If you need to display multi-select values in text input later, you can refer to my previous method.

Thanks for your question here, I hope the rest of the app is friendly, if you think my answer solves your problem or is helpful to you, please accept it as a solution.

Best regards,
Rimmon

Was this reply helpful? Yes No