Depending value

(0) Share

Report

Posted on by common_user

211

Hi all,

I created a collection:

Concurrent(
ClearCollect(List1; Sort(SPlist; ID; Descending));
ClearCollect(List2; Sort(SPlist; ID; Ascending))
);;
ClearCollect(List3;List1;Filter(List2;Not(ID in List1.ID)));;
Clear(List1);;
Clear(List2)

I want to create two object, a comboBox and a textInput.

I would like to show in the textInput field, the corrispondent value that I selected in comboBox items.

How can I do it?

Thank all

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,612 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @common_user ,

Firstly, you can do that with one collection

With( { wLow: Sort( SPList, ID ), wHigh: Sort( SPList, ID, Descending ) }, ClearCollect( colMyList, wLow, Filter( wHigh, !(ID in wLow.ID) ) ) )

but that is not your question - the Default of the Text Box would be

ComboBoxName.Selected.Value

Note Value may be different depending on the Items of the Combo Box

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
BCBuizer 22,800 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @common_user ,

You can set the Default property of the TextInput to ComboBox.Selected.Value for it to display the selected item in the combobox. This will work for a single selection.

If you want to display multiple selected items, use Concat(ComboBox.SelectedItems,Value, " "). This will separate the items with a space, but you can replace that with anything else.

Was this reply helpful? Yes No
common_user 211 on at

Like (0)

Report
Copy link

Link copied!

Hi @BCBuizer, @WarrenBelz ,
I have another problem. I have import a table to excel with 3600 rows. Table name is TAB

ID City
1 New york
2 London
... ...
3000 Miami

In the comboBox Items property I have Tab.ID and I can select all ID.
I want to insert a label or textInput where can I show the corrispondent city.
For e.g. if i select in comboBox ID=3000, I would like to autofill the label/textInput with Miami.

Can you help me please?
I try every possible solution but I'm new in this word and I have some problem.

Thanks all

Was this reply helpful? Yes No
common_user 211 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz can I do the same with your soluction? can I create a collection and then find a specific row?
Thanks

Was this reply helpful? Yes No
common_user 211 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz I resolve my problem thank you! I created only one collection with your code and then I connected to gallery with a filter. I have a last question, how many records can I load on the collection?

Was this reply helpful? Yes No
WarrenBelz 155,612 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @common_user ,

The most is your Delegation limit, which is a maximum of 2,000.

Was this reply helpful? Yes No