Answered

How to display the data from different column based on selected result in combo box

(0) Share

Report

Posted on by Ha-wold

Hello, I am having a hard time on how can I display the data from different column based on my selected result in combo box. Already searched different video tutorials online but most of it use a dropdown box and value.

This is the current information in my Sharepoint:

The current formula on my Textbox - Default Property is:

ComboBox4.Selected.'Model Name'.Result

However, the said formula has an error saying "Name isn't valid. This identifier is not recognized", "Invalid use of '.'"

To add: my second combo box formula in Items Property is:

Filter(Distinct(Filter('SP Name', 'Column Name of Combo Box 1' = ComboBox1.Selected.Result),'Column Name of Combo Box 2'),Result)

Any advise on how can I display the information based on my selected data in combo box?

Thank you!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Ha-wold,

Do you want to display different column value based on the ComboBox selected value?

Could you please share a bit more about your scenario, how many ComboBoxes and represented column name?

Actually, a Combo Box represents a single column value and ComboBox.Selected.REsult represents the combo box selected item from the corresponding single column you populated the ComboBox with.

If you populate a ComboBox using the Distinct() function, you could only display the selected value by reference to the Result. If you want to display value from other column, you should use the LookUp or Filter to display it in the TextInput as below:

LookUp('SP Name', 'Column Name of Combo Box 4'=ComboBox4.Selected.Result).'Model Name'

Here I assume each record has unique model name and it will always return the model name from the first record met the condition if you have duplicated model names.

Provide more details if the above could not solve your issue.
Ha-wold 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft thank you so much for your response. Yes, I actually wanted to display different column value based on the ComboBox selected value.

However when I tried to use the solution you provided, I encountered an error that says "There's an error in this formula. Try revising the formula and running it again. Data type: Record)

I also forgot to mention that the column type is Person or Group Type.

Please advise. Thank you!
Verified answer

Ha-wold 32 on at

Like
a
(1)

Report
Copy link

Link copied!
This can be close. Updated my code to:
LookUp('SP Name', 'Column Name of Combo Box 4'=ComboBox4.Selected.Result, 'Model Name'.DisplayName)

Thanks!