Calculate Min value for a column in SharePoint

(0) Share

Report

Posted on by Sri

559

Hi all,

I have a combo box which filters the names of the account. When the combo box is selected it must filter the nps score for the selected name and if it is less than 9 it must give popup.

The code on On change of Combo box is :

If(

!Is Blank(ComboBox1_7.Selected),

Min(

Filter(

ResponseListData,

'Account Name' = ComboBox1_7.Selected.Value

).NPS,

NPS < 9

Update Context({toggle popup: true})

)

But even if it is less than 9 the popup is not working,

Any help/suggestion on this?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Uthhra ,

The popup will work when combo box is blank, please check the logic of your formula.

If you want to get popup as well when get min value, you should use &&.

If( !Is Blank(ComboBox1_7.Selected), Min( Filter( ResponseListData, 'Account Name' = ComboBox1_7.Selected.Value ).NPS, NPS < 9 )&& Update Context({toggle popup: true}) )

Best regards,

Rimmon

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @Uthhra

you can also try this:

If( !IsBlank(ComboBox1_7.Selected), If( Min(Filter(ResponseListData, 'Account Name' = ComboBox1_7.Selected.Value).NPS) < 9, UpdateContext({togglePopup: true}) ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Uthhra ,

Try this

If( Len(ComboBox1_7.Selected.Value) > 0, With( { _Data: Filter( ResponseListData, 'Account Name' = ComboBox1_7.Selected.Value ) }, UpdateContext( { 'toggle popup': Min( _Data, NPS ) < 9 } ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
But popup is displaying even though the value is less than 9

Was this reply helpful? Yes No
WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Uthhra ,

So you want it to be greater or equal to 9 ?

If( Len(ComboBox1_7.Selected.Value) > 0, With( { _Data: Filter( ResponseListData, 'Account Name' = ComboBox1_7.Selected.Value ) }, UpdateContext( { 'toggle popup': Min( _Data, NPS ) >= 9 } ) ) )

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@mmbr1606
I tried this but getting an error message in .NPS(We expect a number at this point in formula.)

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
When the NPs is less than 9 it must display popup. I tried the above with function code but Popup is not displaying.

Was this reply helpful? Yes No
WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Uthhra

What are you referring to with .NPS - that is not in the code I posted. Also please confirm NPS is a numeric field.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Uthhra ,

Please try this.

If( !Is Blank(ComboBox1_7.Selected)&& Min( Filter( ResponseListData, 'Account Name' = ComboBox1_7.Selected.Value ).NPS)>9, Update Context({toggle popup: false}, Update Context({toggle popup: true})

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
NPS is a numeric field. For filter condition I gave NPS at end this way.
Filter(
ResponseListData,
'Account Name' = ComboBox1_7.Selected.Value
).NPS

Was this reply helpful? Yes No