Pick up dropdown value based on sum filed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

I am trying to create a mileage log app. Employee can add their mileages.

You can see the screenshot below.

My question is this:

I have a filed called Total Mileage which summing up the total mileage column’s value.

The app retrieving data form SharePoint list.

When the Total Milage value is equal or less than 10.000, I want the payment option dropdown filed value to be/shown 0.45 option value otherwise the option value should be 0.25.

Total Mileage =Sum ('Mileage Log','Total Mileage')

Mileage Log is the list name in SharePoint.

If the total mileage=SUM (end mileage- start mileage)

Hope some of you would be able to come up with a solution.

Thank you in advance.

Kind Regards Mileage Screen.png

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous，

Could you please tell me that how you set the Items property of the payment option dropdown?

Do you want to filter the payment option dropdown filed value based on the Total Mileage result?

Not sure about the column type of the Payment Option column, Choice or Text?

I assume that it is a Choice column type, please check the following formula.

Set the Items property of the payment option dropdown as below:

If(Sum(TextInput_StartMileage.Text,TextInput_EndMileage.Text)<=10, Filter(Choices('Mileage Log'.'Payment Options'),Value="0.45"), Filter(Choices('Mileage Log'.'Payment Options'),Value="0.25") )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Qi ,
Thanks very much for your reply.

The "Payment Options" is choose column/filed and has two values/options: 0.45 and 0.25. Please see the screenshot below.

The total mileage text string is: Sum('Mileage Log','Total Mileage') and the name of the label is: LabelTotalMileage

The following code is working but it hides one of the value (0.45 or 0.25) based on 600 and user still has to select the value from dropdown option.

If(Sum('Mileage Log','Total Mileage')<=600,
Filter(Choices('Mileage Log'.'Payment Options'),Value="0.45"),
Filter(Choices('Mileage Log'.'Payment Options'),Value="0.25")
)
Is there any way, the value can automatically be populated into the filed rather than the user has to choose it.

Thanks again.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous，

Please try to set the DefaultSelectedItems property as below:

If(Sum('Mileage Log','Total Mileage')<=600, Filter(Choices('Mileage Log'.'Payment Options'),Value="0.45"), Filter(Choices('Mileage Log'.'Payment Options'),Value="0.25") )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Qi , That worked nicely. I assume that I do NOT need to "Set the Items property" value to.

If(Sum('Mileage Log','Total Mileage')<=600,
Filter(Choices('Mileage Log'.'Payment Options'),Value="0.45"),
Filter(Choices('Mileage Log'.'Payment Options'),Value="0.25")
)

I can leave it as default value which is : Choices([@'Mileage Log'].'Payment Options').

Best Wishes
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Generally, you could set the Items as

Choices([@'Mileage Log'].'Payment Options')

, and set the DefaultSelectedItems property as your If() statement.

If your issue has been solved, please mark my solution as answer.

Thanks for your co-operation.
Faizi 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a contract tracking sheet in Power Apps. I have 5 KPIs as drop down value types. and another data card which is Total Rating. I would like to sum the 5 KPIs and to show the total value of 5 KPIs in my Total Rating data card. What formula i should use?