PowerApps need to set a default value based on 4 other selections

[Kam1]

Hi Everyone,

I am trying to build an app for our post department.

The app basically needs a default price setting based on the previous 4 dropdown selections.

The App has a postage list connected with all the pricing information which it looks ups and then submits all the information in another list.

The 4 dropdowns are:
Postage Type, Class, Format (Size), Weight

I have managed to get the PowerApp to populate the information in the dropdowns however the price I think looks up the weight data and picks the first choice that it finds. (not looking up the other information).

On the Price dropdown I have added the following formula: 

Distinct(Filter('Postal service prices', Weight = Dropdown5_1.Selected.Result),Price)

and am aware that the issue starts here possibly as it only looks up weight.

Is there a way to make it lookup the above 4 columns and then pick the correct price? We had an Info Path form that was able to do this however need to move this to a PowerApp now.

Thanks in anticipation

Kam

[Drrickryp · Accepted solution]

Hi @Kam1 

In the OnStart of the app put this formula

Concurrent(
Collect(type,Sort(Distinct('Postal service prices','Postage Type),Result),
Collect(clas,Sort(Distinct('Postal service prices',Class),Result), 
Collect(size,Sort(Distinct('Postal service prices', 'Format (Size)'),Result),  
Collect(wgt,Sort(Distinct('Postal service prices','Weight'),Result) 
)

Set up the 4 dropdowns with items properties as type, clas, size and wgt respectively.

Put a label on the screen and set the Text property to 

Lookup(
        'Postal service prices', 
           AND(
               'Postage Type' = Dropdown1.Selected.Result, 
                Class = Dropdown2.Selected.Result,
               'Format (Size)' = Dropdown3.Selected.Result,
               Weight = Dropdown4.Selected.Result
            ), "Price"
)

[Kam1]

Hi @Drrickryp 

Sorry for the late response, I have been ill and just returned back to work.

A colleague of mine took over this whilst I was off and what he did was on the price column, he added a filter for each of the options so that it looks up the actual row and gets the price information.

Just want to say thank you for replying to my post. I would have tried this, however the user's seem happy with the current fix so will bare this in mind if I ever do something similar

Best Regards

Kam