Answered

Populate textfield with combo box default value

(0) Share

Report

Posted on by VincentSP

Hi,

I have a form with 2 combo boxes and 1 text field (ComboBox5, ComboBox6 and TextInput2) "ComboBox6" further filters the results based on the input of "ComboBox5" using the following code; "Filter('SourceTable', 'FieldName' = ComboBox5.Selected.FieldName)".

The text field is populated based on the selected item in "ComboBox6" using the following code; "ComboBox6.Selected.'FieldName'"

So far everything is working fine.

My issue;

In some cases "ComboBox6" will only return 1 item based on the "ComboBox5" input. In that case I would like to auto-populate "TextInput2". How could I achieve this?

Vincent

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@VincentSP

Please consider changing your Formula on the TextInput2 Default property to the following:

With({items: Filter('SourceTable', 'FieldName' = ComboBox5.Selected.FieldName)}, If(CountRows(items)=1, First(items).'FieldName', ComboBox6.Selected.'FieldName' ) )

I hope this is helpful for you.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @VincentSP

Try setting this as the formula in the TextInput control's Default property:

If( CountRows( Filter(sourcetable, field= ComboBox5.Selected.field ) ) = 1, LookUp( sourcetable,field = ComboBox5.Selected.field, field ), Combobox6.Selected.field )

It's off the top of my head but you could substitute in your sourcetable and fields and see if it works. It should because if the CountRow() is not 1, then a value in the second combobox will need to be selected before the textinput control populates.

Was this reply helpful? Yes No
VincentSP 46 on at

Like (1)

Report
Copy link

Link copied!

Works like a charm!! Thank you!!

Was this reply helpful? Yes No
VincentSP 46 on at

Like (0)

Report
Copy link

Link copied!

Hi Randy,

Hope you can help me out.. would it be possible to hide (visible:False) ComboBox6 if only 1 item is returned based on the ComboBox5 input. I tried using the CountRows function in the visible property of ComboBox5. But without any luck..

Vincent

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@VincentSP

Yes, this should be the Visible property formula:

With({items: Filter('SourceTable', 'FieldName' = ComboBox5.Selected.FieldName)}, !CountRows(items)=1 )

Was this reply helpful? Yes No
VincentSP 46 on at

Like (1)

Report
Copy link

Link copied!

Thank you!!

Was this reply helpful? Yes No