Collection value on text box

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

Iny my app I have various products lists which have their own "Size" values which then have dependent "Waist" and "Leg Length" values based on the "Size" selected.

I have created a collection named "TrouserTable".

Ideally, Id like to have a text box per row under the "Product" column with the default value of Female Black Officer Trousers for the first row and Female Holster Pocket Trousers - Black/Grey for the second row.

These will then set a precedent for the "Size", "Waist" and "Leg Length" columns.

I've worked out I can set the value of the Text field to First(TrouserTable).product - however this will only apply to the first product name and I'm unsure how to get it to specifiy the second product name on the row below?

Any help would be appreciated.

Thanks,

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What may be easiest is to just add a Product Number field and have each one numbered in order. Then you can default to any row you want

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@BrianS

Could you explain how this would work?

I've tried adding a productID (pid) field to the table but I still can't work out how to get this working when "Female Black Office Trousers" is only available on one row... 🤔

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Since you were using first, I assumed you would use 1,2,3,4,... as the IDs so you could just use a LookUp on the ID numbers and get them in order

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@BrianS

So I could use the table column name as "PID" with "1", "2", "3" on each line in the collection right?

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes - That will let you take items in order

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@BrianS still not entirely sure how I should be doing this?

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Maybe I was sent down the wrong path by your using the First() function. Are you trying to get the second row to use the next product type on the list? If that is the case, I have been answering the wrong question.

After re-reading things, I think what you want is to get the text boxes for first set of sizes for each product to show up as the defaults in your form.

Since what you really need is to know exactly what sizes match the products since there are specific combos, you really only want to user to pick one of those sizes and have the list fill in the rest. You do not want people to order an Officer Trouser with a 38 inch waist. So once the distinct list is set you want to search through the list and get just the sizes. The use that to populate the dropdown for size. Then you will need to do a LookUp() to fill in the other fields. But it appears that you really do not want an unlimited selection on these other fields.

If I am wrong again, let me know. There is a video that talks about how to get multiple dropdowns to be set from previous data that may be of use.

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@BrianS

So if a user selects a Size "12" then "41" would automatically select for the waist.

However if being done for Men's products then leg length would be used which is available in 3 different options.

Was this reply helpful? Yes No