web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Building Power Apps / Nearest Higher value
Power Apps - Building Power Apps
Suggested answer

Nearest Higher value

(0) ShareShare
ReportReport
Posted on by Sam70 260
Hi,
 
Below is the data structure of a list.
 
Number Score
10 5
20 10
30 15
40 20
 
On entering a Number, the Score should be listed. This i can get using lookup function. My requirement is that on entering a number (which falls under two numbers, the Score related to the higher value should get listed. Like if i enter 15 then since 20 is the value above 15, the Score i should get is 10).
Lookup(List, Number=15, Score) is not helping me here.
 
Regards
 
 
Categories:
Using Apps Using Formulas
I have the same question (0)
  • Suggested answer
    SebS Profile Picture
    SebS 4,485 Moderator on at
    Nearest Higher value
    Try this one 

    Create a Collection
    ClearCollect(
        colNumberScore,
        { Number: 10, Score: 5 },
        { Number: 20, Score: 10 },
        { Number: 30, Score: 15 },
        { Number: 40, Score: 20 }
    );

    Than Add input call it txtValue
     
    And in text lable

    Add this code 
     
    First(
        Sort(
            Filter(colNumberScore, Number >= Value(txtValue.Value)),
            Number,
            SortOrder.Ascending
        )
    ).Score



     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 740 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 340 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 248 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans