Using part off a text field to determine default values of drop-down fields.

(0) Share

Report

Posted on by Project2021

Hello all,

I have a question I hope someone can solve.

I have a TextInput field that I want to use the auto-fill dropdown fields.

This is the situation:

Brand has the items: "Apple" and "Samsung"

Model has the items: "iPhone" and "Galaxy"

Memory has the items: "32GB" , "64GB" and "128GB"

Now I want to get my default values based on the textinput above.

So if I fill in "Apple" I want the dropdown for brand to show the value "Apple".

And when I fill in "Apple iPhone", I want to get the brand value "Apple" and model value "iPhone" shown.

And so on.

When the value I use in the textinput isn't present in one of the dropdowns then it can just use "1" as default.

So I'm looking for something that search if part of the textinput matches one of the items in de dorpdowns.

Can anyone help me? Thanks in advance!

*EDIT: Maybe it's good to know that the order and values that can be in the text input are not pre determined. So I should also be able to only fill in the memory-value. Or I should be albe to first fill in the memory value and then the brand for example.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

C-Papa 1,836 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, this should do it for the default of the dropdowns, just change 1 to 2 or 3 to get the second or third part of the string and set the TextInput1.Text to your control name

Last(FirstN(Split(TextInput1.Text," "),1)).Result

Was this reply helpful? Yes No
Project2021 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot, it works as you say!
The only little problem I have is that I'm not sure in which order the users will fill in the field.
So if they have a different order then I anticipate then it doesn't work anymore.
"Samsung Galaxy 128GB" works perfectly - "Galaxy Samsung 128GB" or "64GB Samsung Galaxy" doesn't work.
I can work with this solution, but if anyone knows a way to solve the problem above I would be graceful!

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

I can't really see what the point of the text field is, just use the dropdowns and add all of your phones, models numbers and sizes to it and then the data is fixed in the input, so you know the order. At the minute you have two steps to get to one answer.

Was this reply helpful? Yes No
Project2021 40 on at

Like
a
(0)

Report
Copy link

Link copied!

I understand what you mean.
The thing is to simplify my question I used a very small example of the total amount of data I'm gonna have. In the application I want to build there are many more brands, with I donnow how many models etc...

So for users that know exactly what they want it's easy if they can do a search based on one field. I also want users to only select a value that is in one of the dropdows. So eventually the values that are saved are the ones in the dropdows. I'm trying to increase the ease of which users can find the thing they are looking for. It's purely to increase the speed of which users can find the item they want.

Maybe there is a better solution for it, but this is what I thought off.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Project2021 Put this in the default of the 1st dropdown and follow the same pattern for the other 2.

LookUp(Split(Trim(TextInputSearch.Text), " "), Result in ["Apple","Samsung"]).Result
.

Was this reply helpful? Yes No
Project2021 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, I got it to work!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Project2021 Glad to help!

Was this reply helpful? Yes No